Centos6.5 源码安装MySql5.6.33

卸载已经安装过的旧版本mysql

rpm-emysql
rpm-e--nodepsmysql
yumremovemysql

安装MySql

安装mysql依赖包

yum-yinstallmakegcc-c++cmakebison-develncurses-devel

下载mysql5.6.33

网址http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/

wgethttp://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/mysql-5.6.33.tar.gz
tar-zxvfmysql-5.6.33.tar.gz
cdmysql-5.6.33

编译安装

cmake
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/data/mysqldb
-DSYSCONFDIR=/etc
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock
-DMYSQL_TCP_PORT=3306
-DENABLED_LOCAL_INFILE=1
-DWITH_PARTITION_STORAGE_ENGINE=1
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci

make&&makeinstall

配置mysql

chown-Rmysql:mysql/usr/local/mysql
mkdir-p/data/mysqldb
chown-Rmysql:mysql/data
mv/etc/my.cnf/etc/my.bak

初始化mysql

cd/usr/local/mysql
scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/data/mysqldb--user=mysql

启动mysql

cpsupport-files/mysql.server/etc/init.d/mysqld
chkconfigmysqldon
servicemysqldstart

mysql环境变量配置

PATH=/usr/local/mysql/bin:$PATH
exportPATH
source/etc/profile

设置root登录口令

mysql-uroot
mysql>SETPASSWORD=PASSWORD('123456');

（编辑：鄂州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!