RHEL7.2编译安装mysql5.7.13
1、卸载系统自带的MySql或mariadb及boost# rpm -qa|grep mysql
# rpm -qa|grep mariadb
mariadb-libs-5.5.44-2.el7.x86_64
# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.x86_64
# rpm -qa|grep boost
boost-thread-1.53.0-25.el7.x86_64
boost-system-1.53.0-25.el7.x86_64
# rpm -e --nodeps boost-thread-1.53.0-25.el7.x86_64
# rpm -e --nodeps boost-system-1.53.0-25.el7.x86_64
# rpm -qa| grep boost
#
2、查看是否存在mysql用户及组
# cat /etc/group | grep mysql
# cat /etc/passwd | grep mysql
#
3、创建mysql用户和组
# groupadd mysql
# useradd -r -g mysql mysql
#
4、创建mysql安装目录
# mkdir /usr/local/mysql
# mkdir /usr/local/mysql/data
#
5、安装编译软件
yum -y install make gcc-c++ cmakelibaio libaio-devel perl-Data-Dumper net-toolsncurses-devel bison bison-devel gcc-c++ ncurses-devel cmakeperl gcc autoconf automake zlib libxml libgcrypt libtool
6、安装lrzsz，使用lrzsz上传MySql压缩包
# yum install lrzsz
# rz
上传MySql压缩包
7、解压MySql数据包
# tar zxvf mysql-boost-5.7.13.tar.gz
8、cmake
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci-DWITH_BOOST=/root/mysql-5.7.13/boost/ -DWITH_SYSTEMD=1
9、make
make -j 6 \\指定几个线程处理
10、make install \\安装到指定目录
11、更改mysql目录权限
# chown -R mysql:mysql /usr/local/mysql/
12、把mysql的执行路径加入PATH中
# vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin \\把此行加入到最后一行
# source /etc/profile
13、cp配置文件
# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
14、修改/etc/my.cnf
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
server_id = 1
socket = /usr/local/mysql/data/mysql.sock
log-error = /usr/local/mysql/data/mysql.err
15、配置并修改mysqld.service文件
# cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
#
vi /usr/lib/systemd/system/mysqld.service
PIDFile=/usr/local/mysql/data/mysqld.pid \\修改成对应路径
--pid-file=/usr/local/mysql/data/mysqld.pid \\修改成对应路径
# systemctl daemon-reload
16、初始化数据库
#/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
17、启动mysql进程
# systemctl start mysqld
18、登录MySql数据库
# /usr/local/mysql/bin/mysql -u root
19、修改密码
ALTER USER 'root'@'localhost'> 20、远程登录权限
GRANT ALL PRIVILEGES ON *.* TO root@'%'> FLUSH PRIVILEGES;
21、配置mysql自启动
# systemctl enable mysqld
22、为mysql开启防火墙
firewall-cmd --permanent --zone=public --add-port=3306/tcp
页:
[1]