mysqlnd cannot connect to MySQL 4.1+ using the old insecure【解决方法】
来源:互联网 发布:天刀捏脸数据保存 编辑:程序博客网 时间:2024/05/17 09:35
【MySQL】mysqlnd cannot connect to MySQL 4.1+ using the old insecure【解决方法】
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file. SQL 错误代码: “7335941”.
是采用兼容格式的密码,而 php5.3的php_mysql; php_pdo_mysql 采用的是增强的密码,所以导致两者不匹配,最方便的方式还是更新db的设置,取消 old_passwords
然后在 mysql.mysql.user,更新所有用户的密码, 如:
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;
转载自:http://lampblog.org/1430.html
0 0
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure【解决方法】
- 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 authenticat
- 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 cannot connect to MySQL 4.1+ using old authentication
- mysqlnd连接数据库的问题(mysqlnd cannot connect to mysql 4.1+ using old ..)
- php连接MySQL时产生错误:mysqlnd cannot connect to MySQL 4.1+ using old authentication
- php 5.3:connection failed:SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using old auth
- Error: MySQL server is requesting the old and insecure pre-4.1 auth mechanism.
- MySQL 4.1+ using old authentication
- Using the VirtualBox to work on the old software
- Python 2.7(3.x)以及numpy、matplotlib和scipy库三种方法实战安装
- Linux/Unix time时间戳的处理转换函数
- 移动前端系列——移动端页面坑与排坑技巧
- Gson把对象转成json格式的字符串
- CentOS7搭建VPN(pptpd)服务器
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure【解决方法】
- Win7关闭休眠方法
- Servlet--传参和接参
- 有种生活态度叫 Linux
- Keil MDK 和 IAR 两款ARM开发工具区别比较
- ndk编译常见问题
- strtol函数使用
- OC对象给分类添加属性
- 解决OSX Yosemite中没有 /usr/include