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”
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31470622/viewspace-2141623/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31470622/viewspace-2141623/