中国军事实力,末世之魔女重生,杨含奇
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> mysql client does not support authentication protocol requested by server; consider upgrading mysql client
to solve this problem, you should use one of the following approaches:
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.
mysqld
with the --old-passwords
option.
mysql> select host, user, password from mysql.user -> where length(password) > 16;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 .
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
小白安装登录mysql-8.0.19-winx64的教程图解(新手必看)
Navicat连接MySQL时报10060、1045错误及my.ini位置问题
网友评论