Mysql password Error in PHP

Question

When i try to connect a remote mysql server from my localhost i get this error:

Could not connect: 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

Any idea why it gives this error?

related question: stackoverflow.com/q/10420831/1031312

Ozzy
– Ozzy

2013-08-24 12:49:55 +00:00
Commented Aug 24, 2013 at 12:49 — Ozzy
– Ozzy, Commented Aug 24, 2013 at 12:49

Pascal MARTIN · Accepted Answer · 2011-04-16 14:23:29Z

4

It gives this error because your MySQL server uses the old way of storing password -- and not the new way, which is more secure.

The mysqlnd driver, which has been introduced with PHP 5.3, doesn't support the old authentication way.

So, you have to modify your MySQL configuration, to use the new, more secure way.
The error message you get is indicating you how to do that.

answered Apr 16, 2011 at 14:23

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aqm · Accepted Answer · 2014-02-18 14:26:14Z

1

this helped me

http://www.phpro.org/articles/Database-Connection-Failed-Mysqlnd-Cannot-Connect-To-MySQL.html

quick fix

as db user

SET SESSION old_passwords=0; 
SET PASSWORD=PASSWORD('my_password');

as admin

FLUSH PRIVILEGES;

real fix

open up your my.conf file and comment out the following line

old_passwords=1

Restart MySQL. this will ensure MySQL never uses the old passwords again.

as db user

SET PASSWORD=PASSWORD('my_password');

as admin

FLUSH PRIVILEGES;

answered Feb 18, 2014 at 14:26

aqm

3,03226 silver badges30 bronze badges

Comments

satnhak · Accepted Answer · 2011-04-16 14:24:15Z

0

It seems to be an issue when running PHP <=5.2 code in PHP 5.3+: http://forums.mysql.com/read.php?52,403493,411125#msg-411125

answered Apr 16, 2011 at 14:24

satnhak

9,9707 gold badges68 silver badges87 bronze badges

Collectives™ on Stack Overflow

Mysql password Error in PHP

3 Answers 3

Comments

quick fix

real fix

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

quick fix

real fix

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related