Client does not support authentication protocol requested by server; consider upgrading MySQL Client
来源:互联网 发布:python文件间函数调用 编辑:程序博客网 时间:2024/05/09 08:40
解决方法:
先用root登录MYSQL服务器,执行
mysql>set password for user1@"localhost"=old_password('yourPassword');
原因是因为你使用的mysql服务器版本中使用了新的密码验证机制,这需要客户端的版本要在4.0以上,原来的密码函数被改为old_password();,这样使用password()生成的密码在旧的版本上的客户端就不好使了,而PHP中的MYSQL客户端都是3.23的(当然,mysqli的扩展除外),问题就在这了。
- 烦人的问题:Client does not support authentication protocol requested by server; consider upgrading MySQL client
- 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
- Client does not support authentication protocol requested by server; consider upgrading MySQL Client
- Client does not support authentication protocol requested by server; consider upgrading MySQL client
- MYSQL 新版出现" Client does not support authentication protocol requested by server; consider upgrading MySQL client"解决办法
- [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
- Mysql 连接提示 Client does not support authentication protocol requested by server; consider upgrading MySQL client 解决方法
- linux解决:Client does not support authentication protocol requested by server; consider upgrading MySQ
- Client does not support authentication protocol requested by server: MYSQL
- 解决:Client does not support authentication protocol requested by server
- Client does not support authentication protocol requested by server;
- MYSQL 错误:Client does not support authentication protocol requested by server;
- MySQL 版本错误处理(Client does not support authentication protocol requested by server)
- MySQL 版本错误处理 (Client does not support authentication protocol requested by server)
- 错误MySQL 返回: #1251 - Client does not support authentication protocol requested by server
- MySQL 版本错误处理 (Client does not support authentication protocol requested by server)
- 又是一年了。
- 成功的必要条件
- php函数call_user_func和call_user_func_array详解
- 写给2011
- Dwr新手学习笔记1
- Client does not support authentication protocol requested by server; consider upgrading MySQL Client
- AFX_MANAGE_STATE(AfxGetStaticModuleState()) 宏的使用
- windows环境变量 set使用
- sql server批量修改表名
- 写博客需要理由吗?
- 2010年不容错过的223张互联网数据图
- python插入记录后取得主键id的方法(cursor.lastrowid和conn.insert_id())
- ROC Robot Operating System
- 360浏览器带给站长们的无奈