记录navicat12连接mysql 2048

Ikko Lv3
  2023-03-26 23:00 2023-03-26 23:00 Created   2023-03-29 20:23:52 2023-03-29 20:23:52 Updated  64 Words  1 Mins  

原因是mysql8版本修改了密钥认证方式，需要进行修改

mysql -u root -p

ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘password.’ PASSWORD EXPIRE NEVER;

这样会输出ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@’localhost’

ALTER USER ‘root‘@’%’ IDENTIFIED WITH mysql_native_password BY’password’;

FLUSH PRIVILEGES;刷新权限

  • Title: 记录navicat12连接mysql 2048
  • Author: Ikko
  • Created at : 2023-03-26 23:00:00
  • Updated at : 2023-03-29 20:23:52
  • Link: https://redefine.ohevan.com/2023/03/26/navicat连接mysql-2048/
  • License: This work is licensed under CC BY-NC-SA 4.0.
 Comments
On this page
记录navicat12连接mysql 2048