Navicat for MySQL连接MySQL出现错误1251与1045

时间:2024-04-07 07:35:02

     (假设当前服务器名称为:mysql   密码:123456)

1、Navicat连接Mysql8.0.11出现1251错误

      ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则

      ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码 

      FLUSH PRIVILEGES; #刷新权限

2、Navicat连接Mysql8.0.11出现1045错误

      ALTER USER USER() IDENTIFIED BY ‘新密码’;

收集MYSQL的命令:

      查询mySQL服务器名称:sc query mysql

      删除mySQL服务器名称:sc delete mysql

      启动mySQL服务器:net start mysql

      进入mySQL控制台:mysql -u root -p123456

Navicat for MySQL连接MySQL出现错误1251与1045