MySQL安装

1、解压

tar -zxvf mysql-8.0.20-el7-x86_64.tar.gz

2、改名及将文件转移位置

mv mysql-8.0.20-el7-x86_64   /usr/local/mysql8

3、设置配置文件（/etc/my.cnf）

[client]
port=3306
socket=/tmp/mysql8/mysql.sock


[mysqld]
port=3306
user=mysql
character_set_server=utf8mb4
collation-server=utf8mb4_general_ci
basedir=/usr/local/mysql8
datadir=/usr/local/mysql8/data
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

skip-grant-tables   # 在mysql安装完成后，将此行配置注释，然后进行密码重置

#mysql_native_password
#default_authentication_plugin=mysql_native_password

[mysqld_safe]
log-error=/var/log/mysqld/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

4、创建 mysql 用户组和 mysql 用户

useradd -m mysql

groupadd  mysql 

5、修改权限（根据配置文件建的文件夹进行权限修改）

chown -R mysql:mysql   <file>文件夹

6、初始化

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

 

 7、将  skip-grant-tables  注释，登录MySQL，进行密码重置

./mysql -uroot -h 127.0.0.1 -p

 8、navicat连接：

#配置文件中将此配置放开
default_authentication_plugin=mysql_native_password

 

错误解决： 

此错误：client does not support authentication

  mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
  Query OK, 0 rows affected (0.10 sec)

  mysql> flush privileges;

  Query OK, 0 rows affected (0.01 sec)