MYSQL出现" Client does not support authentication "的解决方法(mysql出现箭头)

编辑：rootadmin

MYSQL 帮助：A.2.3 Client does not support authentication protocol

MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:

shell> mysqlClient does not support authentication protocol requestedby server; consider upgrading MySQL client

To solve this problem, you should use one of the following approaches:

Upgrade all client programs to use a 4.1.1 or newer client library. When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password. Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function: mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');Alternatively, use UPDATE and FLUSH PRIVILEGES: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user';mysql> FLUSH PRIVILEGES;Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one. Tell the server to use the older password hashing algorithm: Start mysqld with the --old-passwords option. Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query: mysql> SELECT Host, User, Password FROM mysql.user -> WHERE LENGTH(Password) > ;For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.

For additional background on password hashing and authentication, see section 5.5.9 Password Hashing in MySQL 4.1.

推荐整理分享MYSQL出现" Client does not support authentication "的解决方法(mysql出现箭头)，希望有所帮助，仅作参考，欢迎阅读内容。

文章相关热门搜索词:mysql is full,mysql出现箭头,Mysql出现由于一段时间没有正确答复,mysql提示,Mysql出现由于一段时间没有正确答复,Mysql出现由于一段时间没有正确答复,mysql出错,Mysql出现由于一段时间没有正确答复,内容如对您有帮助，希望把文章链接给更多的朋友！

经测试最好用的mysql密码忘记的解决方法最好用的mysql密码忘记的解决方法，经过测试，如果不能成功一般是你的mysql运行的不正常解决办法：在windows下：打开命令行窗口，停止mysql服务：Netstop

MYSQL常用命令与实用技巧一、连接MYSQL。格式：mysql-h主机地址-u用户名－p用户密码1、例1：连接到本机上的MYSQL。首先在打开DOS窗口，然后进入目录mysqlbin，再键入命令mysql-uroot-p

用mysqldump备份和恢复指定表的方法 mysqldump-uuser-pdbtab1tab2db.sql恢复mysql-uuser-pdbdb.sql参考：1.拷备文件:(保证数据库没有写操作(可以给表上锁定))直接拷贝文件不能移植到其它机器上，除非你

标签: mysql出现箭头

本文链接地址:https://www.jiuchutong.com/biancheng/319851.html 转载请保留说明！

上一篇：mYsql日期和时间函数不求人(mysql日期和时间分开存的索引)

下一篇：经测试最好用的mysql密码忘记的解决方法(好用的测试工具)