目錄

• yum安裝MySQL8
• • 安裝MySQL8.0資源庫
  • 安裝MySQL8.0
  • 啟動MySQL并配置開機自啟
  • 查看默認密碼并重置
• 使用MySQL8.0踩的坑
• • 授權方式改變
  • 無法遠程連接
  • 加密規則的改變
  • update修改密碼，密碼字段名稱更改

yum安裝MySQL8

安裝MySQL8.0資源庫

yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

安裝MySQL8.0

yum install mysql-community-server

啟動MySQL并配置開機自啟

systemctl start mysqld systemctl enable mysqld

查看默認密碼并重置

• 查看密碼

grep 'temporary password' /var/log/mysqld.log

• 登錄并重置密碼

mysql -pt&ki3u&+ib7X mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

這個與validate_password_policy的值有關, mysql8.0更改了validate_password_policy相關的配置, 這跟Mysql5.7有點不一樣

• 修改密碼校驗規則與密碼長度

mysql> set global validate_password.policy=0; Query OK, 0 rows affected (0.00 sec)mysql> set global validate_password.length=1; Query OK, 0 rows affected (0.00 sec)

• 繼續修改密碼

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; Query OK, 0 rows affected (0.03 sec)

• 退出后重新登錄

[root@zabbix-server ~]# mysql -p123456 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 8.0.22 MySQL Community Server - GPLCopyright (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> mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.22 | +-----------+ 1 row in set (0.00 sec)

使用MySQL8.0踩的坑

授權方式改變

• mysql5.7

mysql> grant all privileges on *.* to 'kevin'@'%' ;

• mysql8.0

mysql> grant all privileges on *.* to 'kevin'@'%' with grant option;

無法遠程連接

MySQL8.0默認是不能使用root賬戶遠程登錄的

• 修改為可以遠程登錄

mysql> update mysql.user set host='%' where user="root"; mysql> flush privileges;

加密規則的改變

mysql8 之前的版本中加密規則是mysql_native_password, 而在mysql8之后,加密規則是caching_sha2_password

使用navicat進行mysql登錄時出現彈窗報錯

修改方式一是：升級navicat驅動，二是：把MySQL用戶登錄密碼加密規則還原成mysql_native_password

#修改加密規則 mysql> ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; Query OK, 0 rows affected (0.16 sec)#更新一下用戶的密碼 mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; Query OK, 0 rows affected (0.08 sec)#刷新權限 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.03 sec)

update修改密碼，密碼字段名稱更改

mysql>update user set authentication_string=password("root") where user='root' and host='localhost';

總結

以上是生活随笔為你收集整理的CentOS下yum安装MySQL8.0的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。