centos7.6 二进制安装mysql 8.0.20

1.下载mysql8.0.20版本

下载地址：下载地址

2. 卸载主机自带的mysql或mariadb

[root@liandoyun ~]# rpm -qa|grep mysql
[root@liandoyun ~]# rpm -qa|grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
[root@liandoyun ~]# rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

3. 安装mysql8.0.20

上传安装包至/root，解压到/usr/local/

[root@localhost local]# tar -zxvf mysql-8.0.20-el7-x86_64.tar.gz
mv mysql-8.0.20-el7-x86_64 mysql

4.创建mysql用户和组

[root@liandoyun mysql]# groupadd mysql  
[root@liandoyun mysql]# useradd -r -g mysql -s /bin/false mysql

5.创建目录并授权

[root@liandoyun mysql]# mkdir /var/lib/mysql
[root@liandoyun mysql]# mkdir /usr/local/mysql/log
[root@liandoyun mysql]# mkdir /usr/local/mysql/data

[root@liandoyun mysql]# chown -R mysql:mysql /usr/local/mysql
[root@liandoyun mysql]# chown -R mysql:mysql /var/lib/mysql

6.添加环境变量

[root@liandoyun mysql]# vim ~/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
[root@liandoyun ~]# source ~/.bash_profile 

7.配置参数文件 vim /etc/my.cnf

[mysql]
default-character-set=utf8mb4
socket=/var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
character-set-server=utf8mb4
default-storage-engine=INNODB
innodb_buffer_pool_size = 200M
max_allowed_packet=128M
explicit_defaults_for_timestamp=1
log-output=FILE

slow_query_log = ON
slow_query_log_file=/usr/local/mysql/log/liandodb_query.err
long_query_time=5
log-error=/usr/local/mysql/log/liandodb_error.err
default-authentication-plugin=mysql_native_password
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
wait_timeout=31536000
interactive_timeout=31536000
default-time_zone = '+8:00'
max_connections=15000
max_connect_errors = 1000
server-id = 1
log_bin = mysql-bin

8.数据库初始化

 /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

9.查看初始化日志

[root@liandoyun mysql]# cd /usr/local/mysql/log/
[root@liandoyun log]# ls
liandodb_error.err  liandodb_query.err
[root@liandoyun log]# more liandodb_error.err 
2020-05-15T03:09:59.555661Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.20) initializing of server in progress as process
 1834
2020-05-15T03:09:59.623225Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-05-15T03:10:03.164817Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-05-15T03:10:08.144133Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: txu2t6_EGBH:

10.配置mysql服务 vim /usr/lib/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 65536
LimitNPROC = 65536

11.启动mysql

[root@liandoyun data]# systemctl daemon-reload
[root@liandoyun ~]# systemctl start mysqld
[root@liandoyun ~]# systemctl status mysqld

12.修改root 密码 默认密码在日志

[root@liandoyun ~]# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.20

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Xdb223300..#';
Query OK, 0 rows affected (0.04 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)

13.设置web用户远程登录

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user from user where user='root';
+-----------+------+
| host      | user |
+-----------+------+
| localhost | root |
+-----------+------+
1 row in set (0.00 sec)

mysql> create USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.03 sec)

mysql> grant all privileges on *.* to 'test'@'%' with grant option;
Query OK, 0 rows affected (0.06 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

更新mysql学习资料：

下载地址

：下载地址