1、去官网下载源码并解压到/usr/local下
地址https://dev.mysql.com/downloads/mysql/
2、安装依赖
yum -y install wget cmake gcc gcc-c++ ncurses ncurses-devel libaio-devel openssl openssl-devel
3、下载boost_1_66_0,并解压到mysql-8.0.11目录下
4、创建mysql用户、创建安装目录和数据目录
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
mkdir -p /usr/local/mysql
mkdir -p /usr/local/mysql/data
5、配置my.cnf文件 vim /etc/my.cnf
修改/etc/my.cnf,如果没有就新建
[mysqld]
socket=/tmp/mysql.sock
symbolic-links=0
server-id=1
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
skip-grant-tables
default_authentication_plugin=mysql_native_password
[mysqld_safe]
!includedir/etc/my.cnf.d
6、修改权限信息
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql/data
chmod 755 /usr/local/mysql -R
chmod 755 /usr/local/mysql/data -R
7、在mysql-8.0.11下执行cmake
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc - DMYSQL_TCP_PORT=3306 -DWITH_BOOST=/usr/local/mysql-8.0.11/boost
cmake成功的标志
cmake成功后,执行make(不要开线程去编译) ,make成功后执行make install
以下操作在/usr/local/mysql目录下
8.初始化
bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data
bin/mysql_ssl_rsa_setup
9.启动mysql
bin/mysqld_safe --user=mysql &
bin/mysql -uroot -p
当输入密码时直接回车
10.在mysql里执行
>use mysql;
>update user set authentication_string=''" where user='root';
然后修改/etc/my.cnf,将skip-grant-tables用#注释掉
11.killd掉mysql进程(ps -e|grep mysql、kill -9 mysql的进程号),然后重启mysql
bin/mysqld_safe --user=mysql &
bin/mysql -uroot -p
当输入密码时直接回车
进入mysql执行
>ALTER user 'root'@'localhost' IDENTIFIED BY '你的密码';
这样就完成了mysql的安装和密码重置