centos7 源码编译安装mysql 5.7.21
生活随笔
收集整理的這篇文章主要介紹了
centos7 源码编译安装mysql 5.7.21
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
1)下載安裝包,?5.7版本需要下載一個(gè)Boost C++ 1.59.0,(下載比較慢)
#cd?/data/soft #?wget?https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21.tar.gz #?tar?-xfzf?mysql-5.7.21.tar.gz #?wget?http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz #?tar?-xfzf?boost_1_59_0.tar.gz??
2)安裝依賴包:
#yum?-y?install?gcc?gcc-c++?ncurses?ncurses-devel?bison?libgcrypt?perl?make?cmake3)建立用戶,授權(quán)安裝目錄和數(shù)據(jù)目錄權(quán)限,這步可以放到編譯完做
#?useradd?-g?mysql?mysql?-s?/sbin/nologin4)編譯安裝
?
#?cmake?-DCMAKE_BUILD_TYPE=RelWithDebInfo?-DCMAKE_INSTALL_PREFIX=/usr/local/mysql?-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock?-DDEFAULT_CHARSET=utf8?-DDEFAULT_COLLATION=utf8_general_ci?-DMYSQL_DATADIR=/usr/lcoal/mysql/data?-DSYSCONFDIR=/etc/my.cnf?-DWITH_MYISAM_STORAGE_ENGINE=1?-DWITH_INNOBASE_STORAGE_ENGINE=1?-DWITH_PARTITION_STORAGE_ENGINE=1?-DENABLE_DEBUG_SYNC=0?-DENABLED_LOCAL_INFILE=1?-DENABLED_PROFILING=1?-DMYSQL_TCP_PORT=3306?-DWITH_DEBUG=0?-DWITH_SSL=yes?-DDOWNLOAD_BOOST=1?-DWITH_BOOST=/data/soft/boost_1_59_0 #?make?&&?make?install #創(chuàng)建mysql用戶(但是不能使用mysql賬號(hào)登陸系統(tǒng)) #?useradd?-g?mysql?mysql?-s?/sbin/nologin #?chown?-R?mysql:mysql?/usr/local/mysql #進(jìn)入安裝路徑,執(zhí)行初始化配置腳本,創(chuàng)建系統(tǒng)自帶的數(shù)據(jù)庫(kù)和表 #?cd?/usr/local/mysql/bin/ #mysqld?--defaults-file=/etc/my.cnf?--initialize?--basedir=/usr/local/mysql?--datadir=/usr/local/mysql/data??--user=mysql #添加服務(wù),拷貝服務(wù)腳本到init.d目錄,并設(shè)置開(kāi)機(jī)啟動(dòng) #?cp?/usr/local/mysql/support-files/mysql.server?/etc/init.d/mysql #?chkconfig?--add?mysql #?chkconfig?mysql?on #service?mysql?start5)開(kāi)啟遠(yuǎn)程連接
#系統(tǒng)提示輸入數(shù)據(jù)庫(kù)root用戶的密碼,輸入完成后即進(jìn)入mysql控制臺(tái) #mysql?-uroot?-p #use?mysql; #GRANT?ALL?PRIVILEGES?ON?*.*?TO?'root'@'%'?IDENTIFIED?BY?'password'?WITH?GRANT?OPTION; #FLUSH?PRIVILEGES;參考博客:
https://www.cnblogs.com/yangchunlong/p/8477743.html
https://www.cnblogs.com/oracleloyal/p/6060779.html
https://blog.csdn.net/wayne_primes/article/details/79565883
https://blog.51cto.com/mofansheng/2110911
https://blog.csdn.net/sun614345456/article/details/53672150
轉(zhuǎn)載于:https://blog.51cto.com/6290105/2136379
總結(jié)
以上是生活随笔為你收集整理的centos7 源码编译安装mysql 5.7.21的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: Software-Defined Net
- 下一篇: qsort归纳学习(c语言版本)