一、下载mysql软件并解压
# tar -zxvf mysql-5.7.22-el7-x86_64.tar.gz
二、查询系统中以前是否安装mysql,如果有就卸载
# rpm -qa|grep -i mysql
# yum remove qt-mysql-4.8.5-11.el7.x86_64
# find / -name mysql
# rm -rf [找到的mysql路径]
三、检查mysql用户和组是否存在,删除原来的用户和组
# cat /etc/group | grep mysql
# cat /etc/passwd | grep mysql
# userdel mysql
四、创建mysql用户和组
# groupadd -g 1170 mysql
# useradd -u 1170 -g mysql mysql
五、安装编译依赖包
# yum -y install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison libaio-devel git boost
六、使用cmake进行生成编译环境:
# cmake -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/u01/app/mysql -DMYSQL_DATADIR=/u01/app/mysql/data -DCMAKE_BUILD_TYPE=RelWithDebInfo -DENABLE_DTRACE=OFF -DWITH_EMBEDDED_SERVER=OFF -DWITH_INNODB_MEMCACHED=ON -DWITH_SSL=bundled -DWITH_ZLIB=system -DINSTALL_PLUGINDIR="/u01/app/mysql/plugin" -DWITH_EDITLINE=bundled -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost \
参数具体含义,参见官方手册
七、安装boost库(在编译的时候回下载boost库,一般都会失败,现在手动下载安装)
# wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz
然后将下载的文件拷贝到:/usr/local/boost下并解压
如果不执行这一步,那么在执行cmake时会报错:
CMake Error at cmake/boost.cmake:187 (MESSAGE): DOWNLOAD_BOOST_TIMEOUT (which is now 600 seconds)
八、执行编译:make
# make
九、执行安装
# make install
十、初始化数据库
# /u01/app/mysql/bin/mysqld --initialize --user=mysql --basedir=/u01/app/mysql --datadir=/u01/app/mysql/data # 注意:在datadir目录下不要创建其他目录,否则初始化不通过
上面语句初始化成功后会在控制台打印临时管理员密码,如下:
2018-08-30T05:55:25.130667Z 1 [Note] A temporary password is generated for root@localhost: U?Y0kwATGFjv
十一、创建socket文件
/etc/my.cnf中配置:socket=/var/lib/mysql/mysql.sock
需要手动建立mysql.sock,并赋值读写执行权限
# touch mysql.sock
# chmod -R 777 mysql.sock
十二、启动后,登陆mysql提示需要重置密码:
mysql> alter user 'root'@'localhost' identified by 'mysql123';
授权root用户可以从任意机器访问mysql服务器:
mysql> grant all privileges on *.* to 'root'@'%' identified by 'mysql123' with grant option;
mysql> flush privileges;
mysql> select host,user,authentication_string,password_expired,account_locked from mysql.user;
+-----------+---------------+-------------------------------------------+------------------+----------------+
| host | user | authentication_string | password_expired | account_locked |
+-----------+---------------+-------------------------------------------+------------------+----------------+
| localhost | root | *F861720E101148897B0F5239DB926E756B1C28B3 | N | N |
| localhost | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | N | Y |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | N | Y |
| % | root | *F861720E101148897B0F5239DB926E756B1C28B3 | N | N |
+-----------+---------------+-------------------------------------------+------------------+----------------+
4 rows in set (0.00 sec)
mysql>
修改/etc/profile文件:
# echo "PATH=$PATH:/u01/app/mysql/bin" >>/etc/profile
# source /etc/profile