共计 1490 个字符,预计需要花费 4 分钟才能阅读完成。
自动写代码机器人,免费开通
这篇文章主要介绍 navicat 中出现 1251 错误的解决方法,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!
navicat 在连接 MySQL8.0 及以上版本的时候,总是报错 1251;原因是 MySQL8.0 版本的加密方式和 MySQL5.0 的不一样,连接会报错,解决方法:
1、先通过命令行进入 mysql 的 root 账户:
PS C:\Windows\system32 mysql -uroot -p
再输入 root 的密码:
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 8.0.11 MySQL Community Server - GPL
Copyright (c) 2000, 2018, 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
2、更改加密方式:
mysql ALTER USER root @ localhost IDENTIFIED BY password PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.10 sec)
3、更改密码:该例子中 123 为新密码
mysql ALTER USER root @ localhost IDENTIFIED WITH mysql_native_password BY 123
Query OK, 0 rows affected (0.35 sec)
4. 刷新:
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.28 sec)
// 如果报错 ERROR 1396 (HY000): Operation ALTER USER failed for root @ %:
则是远程访问权限不正确,先选择数据库,查看一下再更改:
mysql use mysql;
Database changed
mysql select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
最后重新启动 MySQL 服务,在重新连接就行了。
以上是“navicat 中出现 1251 错误的解决方法”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注丸趣 TV 行业资讯频道!
向 AI 问一下细节
正文完