mySQL update 4.0.27 to 4.1.22 breaks code pls help!
Posted: Sun Aug 16, 2009 1:11 am
Hi,
have had a mySQL database running on Godaddy shared linux host for 3 years without problem.
Thought I would like to do some enhancement on it but not wanting to stuff up a working system I thought I would create another mySQL database to test the changes before committing them to go live.
Problem is that the authentication on new DB does not work. Identical code except for the new database name and password.
Using cookie session and password hashing.
The connection obviously occurs because the login window appears, But when the username and password are entered, the query dies and I am returned to the login page.
Since constructing the initial working database, Godaddy is now offering mySQL versions of 4.1.22 or version 5.
The original DB which I dumped and imported into new DB is still in 4.0.27. I Know the password hashing algorithm has changed, and the field size has to be increased to 41 chrs to accommodate this. I can see everything in new DB OK in MySQLFront, and phpMyAdmin, just cant connect via firefox, ie or safari.
Can anyone help me as to where I should look to fix this issue.
TIA
gilk9
have had a mySQL database running on Godaddy shared linux host for 3 years without problem.
Thought I would like to do some enhancement on it but not wanting to stuff up a working system I thought I would create another mySQL database to test the changes before committing them to go live.
Problem is that the authentication on new DB does not work. Identical code except for the new database name and password.
Using cookie session and password hashing.
The connection obviously occurs because the login window appears, But when the username and password are entered, the query dies and I am returned to the login page.
Since constructing the initial working database, Godaddy is now offering mySQL versions of 4.1.22 or version 5.
The original DB which I dumped and imported into new DB is still in 4.0.27. I Know the password hashing algorithm has changed, and the field size has to be increased to 41 chrs to accommodate this. I can see everything in new DB OK in MySQLFront, and phpMyAdmin, just cant connect via firefox, ie or safari.
Can anyone help me as to where I should look to fix this issue.
TIA
gilk9