centos mysql8安装

centos mysql8安装
（在非root用户下安装）

1.下载 mysql8
mysql-8.0.17-el7-x86_64.tar.gz
2. 上传到服务器
如 /home/yanlei/mysql/下

3. 解压
   tar -xzvf mysql-8.0.17-el7-x86_64.tar.gz
   解压后目录名为： mysql-8.0.17-el7-x86_64 ，可以改短一点
   mv mysql-8.0.17-el7-x86_64 mysql8
4. 创建data目录
   /home/yanlei/mysql/data 数据文件目录
   /home/yanlei/mysql/mysql8 mysql目录
5. 初始化数据库：
   /home/yanlei/mysql/mysql8/bin/mysqld --initialize --user=yanlei --basedir=/home/yanlei/mysql/mysql8 --datadir=/home/yanlei/mysql/data

[System] [MY-013169] [Server] /home/yanlei/mysql/mysql8/bin/mysqld (mysqld 8.0.17) initializing of server in progress as process 15643
[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: **5#eKu5<!hIQm**
[System] [MY-013170] [Server] /home/yanlei/mysql/mysql8/bin/mysqld (mysqld 8.0.17) initializing of server has completed

记一下root密码。
6. 配置 my.cnf (/home/yanlei/mysql/my.cnf)

 [mysql]
 default-character-set=utf8mb4 
 [mysqld]
 port = 3389
 max_connections=200
 character-set-server=utf8mb4
 default-storage-engine=INNODB 
 max_allowed_packet=16M
 basedir=/home/yanlei/mysql/mysql8
 datadir=/home/yanlei/mysql/data
 socket=/home/yanlei/mysql/mysql.sock
 pid-file=/home/yanlei/mysql/mysql.pid
 log-error=/home/yanlei/mysql/log/error.log
 lower_case_table_names =2 

7. 启动mysql服务
   /home/yanlei/mysql/mysql8/bin/mysqld --defaults-file=/home/yanlei/mysql/my.cnf

8. root登录
   /home/yanlei/mysql/mysql8/bin//mysql -u root -p 3389 --socket=/home/yanlei/mysql/mysql.sock

9. 修改root密码

    mysql> alter user 'root'@'localhost' identified by 'qseijfseaa'; 

11. 创建用户

    mysql>create user 'yanlei'@'%' identified with mysql_native_password  by 's001441';
    mysql> grant all on mydb.* to 'yanlei'@'%';
    mysql> flush privileges;

用户 yanlei 就可以远程连接到服务器了。
12. 停止mysql 服务

/home/yanlei/mysql/mysql8/bin/mysqladmin shutdown -P 3389 -u root -p --socket=/home/yanlei/mysql/mysql.sock