useradd -s /usr/sbin/nologin -r mysql
下載源碼包以及解壓wget http://dev.mysql.com/get/Downloads/html' target='_blank'>MySQL-5.7/mysql-boost-5.7.21.tar.gztar -zxf mysql-boost-5.7.21.tar.gzcd mysql-5.7.21安裝擴展依賴
yum remove mariadb-libsyum install gcc -yyum install gcc-c++ -yyum install cmake -yyum install libaio -yyum install ncurses-devel -y創建mysql的安裝目錄及數據庫存放目錄
mkdir -p /data/db/mysqlmkdir -p /data/log/mysql編譯安裝mysql
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql /-DSYSCONFDIR=/usr/local/mysql/etc /-DMYSQL_DATADIR=/data/mysql /-DWITH_MYISAM_STORAGE_ENGINE=1 /-DWITH_INNOBASE_STORAGE_ENGINE=1 /-DWITH_PARTITION_STORAGE_ENGINE=1 /-DWITH_SYSTEMD=1 /-DWITH_SSL=system /-DWITH_ZLIB=system /-DWITH_EMBEDDED_SERVER=1 /-DENABLED_LOCAL_INFILE=1 /-DEXTRA_CHARSETS=all /-DDEFAULT_CHARSET=utf8mb4 /-DDEFAULT_COLLATION=utf8mb4_general_ci /-DDOWNLOAD_BOOST=1 /-DWITH_BOOST=/usr/local/boostmake -j8 make install檢驗是否安裝成功
[root@root mysql-5.7.12]# cd /usr/local/mysql/[root@root mysql]# lsbin data include man mysql.sock.lock README support-filesCOPYING docs lib mysql.sock mysql-test share新建目錄
mkdir -p /data/db/mysql/mkdir -p /data/log/mysql/增加配置文件
mkdir /usr/local/mysql/etctouch /usr/local/mysql/etc/my.cnfln -s /usr/local/mysql/etc/my.cnf /usr/local/etc修改權限
chown -R mysql:mysql /usr/local/mysql/*chown -R mysql:mysql /data/db/mysql /data/log/mysql生成初始化密碼
cd /usr/local/mysqlbin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/db/mysqlbin/mysql_ssl_rsa_setupvim /data/log/mysql/error.log查看初始化密碼grep temporary password /data/log/mysql/error.log將mysql的啟動服務添加到系統服務中
cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/systemmkdir -p /var/run/mysqld/chown mysql:mysql /var/run/mysqldsystemctl start mysqldservice mysql start啟動mysql
service mysqld start檢查mysql啟動是否正常service mysqld status 或者 ps -ef | grep mysql設置mysqld服務開機自啟動systemctl enable mysqld.service檢查mysqld開機自啟動是否設置成功systemctl list-dependencies | grep mysqld修改mysql密碼,以及遠程連接權限
ALTER USER root @ localhost IDENTIFIED BY Studytime% use mysql;select host, user from user;update user set host = % where user = root GRANT ALL PRIVILEGES ON *.* TO root @ % IDENTIFIED BY Studytime% WITH GRANT OPTION;FLUSH PRIVILEGES;
以上就是本文的全部內容,希望對大家的學習有所幫助,更多相關內容請關注PHP !
相關推薦:
PHP7.2 Data Structures的使用
php編譯安裝擴展redis及swoole的方法
以上就是linux編譯安裝mysql5.7的詳細內容,PHP教程
鄭重聲明:本文版權歸原作者所有,轉載文章僅為傳播更多信息之目的,如作者信息標記有誤,請第一時間聯系我們修改或刪除,多謝。
新聞熱點
疑難解答