[MySQL] Client does not support authentication protocol的解决
来源:互联网 发布:双肩包 男 知乎 编辑:程序博客网 时间:2024/04/30 12:54
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;
由于MYSQL的新版密码算法与老版有所改变,所以需要用此方法更新表内用户的密码
- [MySQL] Client does not support authentication protocol的解决
- mysql出现Client does not support authentication protocol问题的解决。
- 解决:Client does not support authentication protocol requested by server
- mysql connect Error,Client does not support authentication protocol requested
- Client does not support authentication protocol requested by server: MYSQL
- 烦人的问题:Client does not support authentication protocol requested by server; consider upgrading MySQL client
- mysql客户端工具连接时出现: Client does not support authentication protocol 解决
- Client does not support authentication protocol
- Client does not support authentication protocol
- Client does not support authentication protocol requested
- Client does not support authentication protocol
- Mysql4安装Client does not support authentication protocol requested问题的解决
- Mysql4安装Client does not support authentication protocol requested问题的解决
- Mysql4安装Client does not support authentication protocol requested问题的解决
- MYSQL(解决方法):Client does not support authentication
- Client does not support authentication protocol requested by server; consider upgrading MySQL client
- PHPMYADMIN: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
- #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
- 一段美好的记忆,一份真挚的感情,已经远去......
- 女朋友对男程序员的20大感受
- 新站还有最后一个功能没做,准备用datagrid+datalist来做简单留言本
- Hiweed-Debian 0.6下安装nvidia驱动
- 青春 Youth
- [MySQL] Client does not support authentication protocol的解决
- 昨天骑车环岛被晒伤,今天踢球被雨淋!
- 体验RSS阅读
- 一个人事经理眼中的中国人劣根性
- 微软MM:我在微软的“面试亲历”——唐骏当年就这样录人 [转]
- Debian中文美化
- 【收藏】鱼和水的故事--完整版
- Debian 安装--step by step
- 黑鸡小tips