解决mysqlnd cannot connect to MySQL 4.1+ using the old insec
发布:smiling 来源: PHP粉丝网 添加日期:2015-04-20 14:49:28 浏览: 评论:0
解决mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication错误.
mysqlnd比mysql说使用起来更方便了,但小编在使用时碰到mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication错误了,下面我们一起来看此问题解决办法.
mysqlnd是个好东西,不仅可以提高与mysql数据库通信的效率,而且也可以方便的设置一些超时,如连接超时,查询超时.
但是,使用mysqlnd的时候,有个地方需要注意,就是服务端的密码格式不能使用旧的16位的存储格式,而要使用新的41位的存储格式.
如果服务端的密码格式是16位,那么就会报错,信息如下:
- Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000] [2000] 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’ in /home/hailong.xhl/test.php:8 --phpfensi.com
如何查看自己的密码是否符合要求,so easy.
- mysql> select user,length(password) from mysql.user;
- +--------------+------------------+
- | user | length(password) |
- +--------------+------------------+
- | demo | 16 |
- | demo | 16 |
- +--------------+------------------+
上面的密码是旧的16位格式,如果想改成新的41位格式,通过以下命令就可以.
- mysql>UPDATE mysql.user SET Password = PASSWORD('demo') WHERE user = 'demo';
- Query OK, 2 rows affected (0.00 sec)
- Rows matched: 2 Changed: 2 Warnings: 0
- mysql> select user,length(password) from mysql.user;
- +--------------+------------------+
- | user | length(password) |
- +--------------+------------------+
- | demo | 41 |
- | demo | 41 |
- +--------------+------------------+
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
修改完密码后,还需要在配置文件中修改下old_passwords选项,把值设置为0,即.
old_passwords=0 然后重启mysql.
Tags: mysqlnd cannot connect
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)