[RESOLVED] Can't connect using old auth

potatoCode

Hi
I need some help understanding how connection from php to mysql works.

I made a simple connection php file to test on my pc (localhost) which works fine.
But when I try to connect to a remote server using the same php file,
by simply changing values in the variable
(e.g $host="localhost" to $host="blahblah.sqlserver.com")
I get "mysqlnd cannot connect to MySQL 4.1+ using old authentication.." error.

Why am I getting this error?
Thanks.

Weedpacket

http://www.google.com/search?q=mysqlnd+cannot+connect+to+MySQL+4.1%2B+using+old+authentication

potatoCode

Hi weedpack

before I posted this question,
I googled and tried to follow through the error results but to no prevail.
both php/mysql version on my pc and the remote server is 5/5.

The bigger problem is that I get in to much trouble running the test apps on the remote server
than to have the same apps run locally.

I can't help but feeling I'm not learning it the right way,
or missing out on something that's crucial to understand how web applications work.

I'd appreciate it if you or anyone can point me in the right direction.

Thanks.

shamly

Change your password in the mysql DB as mentioned in below link Should work ..

http://dev.mysql.com/doc/refman/5.1/en/old-client.html

DriverOp

shamly;10924731 wrote:
Change your password in the mysql DB as mentioned in below link Should work ..

http://dev.mysql.com/doc/refman/5.1/en/old-client.html

To fix this error I did the exact opposite of what that website says.
What happens is that MySQL had the password stored in the old format, change the password to the new format.

To check this, open the MySQL console (mysql.exe in Windows) and run:

SELECT Host, User, Password FROM mysql.user;

If the Password column is a 16-digit hexadecimal number, then the password is in the old format.

Then you have to execute:

SET PASSWORD FOR 'your_user'@'your_host' = PASSWORD ( 'your_old_password');

Where your_user is the user name and your_host is the hostname as appear in the corresponding columns and your_old_password' is the old password stored without encription (plain text).

That solved my problem.

Regards.

neilo

Driver Op,

So how did you manage to do that on the remote server?

softcam

Hi developer community.

I'm working with Windows 7 and IIS 7.5, PHP 5.2.13 and MySQL 5.1.46

I had the same trouble.

Trouble: Set the old password:
SET PASSWORD FOR 'mexicoe_progol'@'127.0.0.1'=PASSWORD('miclave');

I then update with the new format password, but it did'n work.
SET PASSWORD FOR 'mexicoe_progol'@'127.0.0.1'=PASSWORD('miclave');

Solution:

I delete my user mexicoe_progol, from mysql.user:
delete from mysql.user where user = 'mexicoe_progol';

Then I granted permissions:
mysql> GRANT ALL PRIVILEGES ON progol.* TO mexicoe_progol@"127.0.0.1" IDENTIFIED
BY 'miclave' WITH GRANT OPTION;

Then I set my password in the new format:
SET PASSWORD FOR 'mexicoe_progol'@'127.0.0.1'=PASSWORD('miclave');

That's worked.

Warm regards.