MySQL5.6.33 源码方式安装

yanghonggang 2016/9/8

环境说明：

服务器：CentOS Linux release 7.1.1503 (Core)

下载地址：http://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.33.tar.gz

开始安装，请确保服务器中已经安装相应的开发工具，如gcc make cmake等

[root@localhost src]# yum -y install cmake ncurses ncurses-devel openssl-devel bison gcc gcc-c++ perl-Data-Dumper

将下载好的mysql 包，上传到服务器的 /usr/loacl/src 目录下，进行解压

[root@localhost src]# tar xvf mysql-5.6.33.tar.gz

[root@localhost src]# cd /usr/local/src/mysql-5.6.33

增加mysql用户组

[root@localhost mysql-5.6.33]# groupadd mysql

Mysql用户不需要家目录不需要登录

[root@localhost mysql-5.6.33]# useradd -M -g mysql -s /sbin/nologin mysql

编译参数环境配置

[root@localhost mysql-5.6.33]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

开始编译安装

[root@localhost mysql-5.6.33]# make && make install

改属主属组

[root@localhost mysql]# cd /usr/local/mysql/

[root@localhost mysql]# chown -R mysql.mysql .

进行数据的初始化

[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

添加mysql到系统服务

[root@localhost mysql]# rm /etc/my.cnf

[root@localhost mysql]# cp support-files/my-default.cnf  /etc/my.cnf

[root@localhost mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld

[root@localhost mysql]# chmod 755 /etc/rc.d/init.d/mysqld

[root@localhost mysql]# chkconfig --add mysqld

[root@localhost mysql]# service mysqld start

Starting MySQL. SUCCESS!

将mysql添加到环境变量

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

source /etc/profile

授权：

grant all privileges on *.* to “root”@“%” identified by “123456”