[SOLVED]Php 5.3 MySql Error Old Password Format

I ran into this problem when I tried to import my v5 project into v6. I develop on my home windows7 machine and connect remotely to my webserver mysql db on my hosting server. The hosting company has mysql Ver 5.1 +, but I got this error when trying to connect with V6 (PHP5.3):

Connection Error
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

I have found that some webhosts have left the default settings in mysql my.cnf file which is

This article explains the fix and why this happens with php 5.3:

http://lampsailesh.blogspot.com/2011_05_01_archive.html#5294498109303285481

Also mentioned here on the dev.mysql site:

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

My question is; Will this be an issue when deploying a V6 application? Or will the apps run fine no matter how mysql is setup on the host?

Re: Php 5.3 MySql Error Old Password Format

My hosting company is offering to move my account to a php 5.3 server.

  1. If I do this will applications developed in SC V5 work on the server once they are deployed and connect to MySql ok? See my post above.

  2. Will applications developed in V6 work on servers that do not support PHP 5.3? I’ve already determined that I can not connect to MySql on a server that has 5.21 installed on it unless the MySql config file is modified. See the articles above.

Re: Php 5.3 MySql Error Old Password Format

Hello,

You have to use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘Your MySQL Password’).

Yes, as long as you do the procedure above.

V6 applications will not run on properly on PHP 5.2 environments.

regards,
Bernhard Bernsmann

Re: Php 5.3 MySql Error Old Password Format

Thanks Bernhard,

I am getting the connection issue resolved with my host. I understand that scriptcase V6 will not run properly on any php version less than 5.3.

My question is will applications that are developed with V6 run ok on servers that are running php 5.2 or lower? Sorry if I didn’t make that clear in my first post.

Re: Php 5.3 MySql Error Old Password Format

Hello rickallen,

Actually I was the one that wasn’t very clear :P. Any applications developed (deployed) on ScriptCase 6 will not run properly - as in, many things won’t work - on servers running PHP 5.2 or lower.

regards,
Bernhard Bernsmann

Re: Php 5.3 MySql Error Old Password Format

Ouch! A lot of host are running less than php 5.3. Glad we are allowed to run V5 and V6 at same time.

Re: Php 5.3 MySql Error Old Password Format

I really do not see how this is related to PHP version. I have the same problem. I have desktop App which connects to my DB without problems, I can also connect from MySQL Admin tool and Query Tool but not SC6. SC6 says in an Error I use MySQL v4.1 while I use v5.5,… so it is all garbage. It almost sure it is an internal SC6 problem. I used SC6 before with another App and the same host and same MySQL version and have had no problem.

I also do not understand why would I need to reset my password (it is pretty much well encrypted and secure) (?)
I did that, and still cannot connect !

Arthur

Re: Php 5.3 MySql Error Old Password Format

did some research. My ISP is running MySQL 5.1 and PHP 5.3,…I still cannot connect with SC6, but I can with SC5
any clue ?

Arthur

Re: Php 5.3 MySql Error Old Password Format

Hello,

This error was generated by the database, where the solution is shown:

“Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’)”.

You only need to change the user password, is mostly common the user is ?root?

PS: You can change to the older password, use the manager or through a command line

regards