Centos7源码编译安装mysql

mysql下载

http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.24.tar.gz
通过ftp上传至/root/目录下

安装

#解压
tar -zxvf mysql-5.7.24.tar.gz
#安装相应依赖
yum install make cmake gcc gcc-c++ bison bison-devel ncurses ncurses-devel autoconf automake wget
#下载boost
mkdir /usr/local/boost
wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz --no-check-certificate
#添加用户并创建相应目录存放数据
mkdir /home/mysql
mkdir data logs temp
useradd mysql
chown -R mysql:mysql data logs temp
#执行cmake

		cmake \
        -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
        -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
        -DDEFAULT_CHARSET=utf8 \
        -DDEFAULT_COLLATION=utf8_general_ci \
        -DWITH_MYISAM_STORAGE_ENGINE=1 \
        -DWITH_INNOBASE_STORAGE_ENGINE=1 \
        -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
        -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
        -DWITH_MEMORY_STORAGE_ENGINE=1 \
        -DWITH_READLINE=1 \
        -DENABLED_LOCAL_INFILE=1 \
        -DMYSQL_DATADIR=/home/mysql/data \
        -DMYSQL_USER=mysql \
        -DMYSQL_TCP_PORT=3306 \
        -DWITH_BOOST=/usr/local/boost

#进行编译
make
#安装
make install
#修改mysql安装目录的权限
chown -R mysql:mysql /usr/local/mysql
#初始化mysql
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data
会产生一个字符串作为初次登录的密码
#修改环境变量
vim /etc/profile
添加以下内容：
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
#生效
source /etc/profile
#删除/etc下的my.cnf
rm -rf /etc/my.cnf
#复制服务启动脚本
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
#启动 MySQL 服务
service mysql start
#设置mysql服务开机自启动
chkconfig mysql on
#进行初次登录mysql并修改初始密码
mysql -u root -p 敲回车
输入密码，进入mysql控制台
#修改初始化生成的密码
mysql> SET PASSWORD = PASSWORD(‘root’);
mysql> ALTER USER ‘root’@‘localhost’ PASSWORD EXPIRE NEVER;
mysql> flush privileges;
mysql>exit;
#使用修改的密码重新登录并设置可远程登录
mysql -u root -p 敲回车
输入密码，进入mysql控制台
mysql> flush privileges;mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;
mysql> flush privileges;
mysql>exit;
#开放3306端口
firewall-cmd --permanent --add-port=3306/tcp
#重启防火墙
systemctl restart firewall.service
#测试
使用navicat进行连接测试