mysqlnd cannot connect to MySQL 4.1+ using old authentication
来源:互联网 发布:post请求数据加密 编辑:程序博客网 时间:2024/04/30 19:53
报这个错误主要是因为mysql使用了老的密码格式,而程序要求使用新的格式导致的,解决办法:
SET old_passwords = 0;UPDATE mysql.user SET Password = PASSWORD('testpass') WHERE User = 'testuser' limit 1;SELECT LENGTH(Password) FROM mysql.user WHERE User = 'testuser';FLUSH PRIVILEGES;
使用新的密码格式重新生辰密码就ok了。
0 0
- mysqlnd cannot connect to MySQL 4.1+ using old authentication
- php连接MySQL时产生错误:mysqlnd cannot connect to MySQL 4.1+ using old authentication
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication问题解决
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication错误解决办法
- Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- 在万网虚拟主机上连接数据库出错mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysqlnd连接数据库的问题(mysqlnd cannot connect to mysql 4.1+ using old ..)
- php 5.3:connection failed:SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using old auth
- Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authenticat
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure【解决方法】
- MySQL 4.1+ using old authentication
- Could not connect: Connection using old (pre-4.1.1) authentication protocol
- mysql_connect(): Connection using old (pre-4.1.1) authentication protocol refused
- 2014 想做一个全新的自己
- cocos2d-x-2.2.0版本的CocoStudio的GUI绑定到lua
- OpenGL学习二十:纹理函数
- 史上最全Linux提权后获取敏感信息方法
- 物联网 毕业设计——社交物联网系统的思考
- mysqlnd cannot connect to MySQL 4.1+ using old authentication
- kNN:最近邻分类器
- JQuery TextArea的取值与赋值问题
- 21个常用的PHP函数代码段
- 详解Objective-C runtime
- 各种字符串Hash函数
- 构建自己的Linux系统反思(一)
- hdu 1569 方格取数(2) 最大点权独立集
- IOS UIView 之实例方法篇 Instance Methods