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
mySQL update 4.0.27 to 4.1.22 breaks code pls help!
Moderator: General Moderators
Re: mySQL update 4.0.27 to 4.1.22 breaks code pls help!
generate a new password or reset it for your main user. if you can't do it yourself, ask your provider to do it for youI Know the password hashing algorithm has changed
Re: mySQL update 4.0.27 to 4.1.22 breaks code pls help!
Thanks for the reply, but it is not relevant because I can do all that thru phpMyAdmin, and even create new test users with the new 41 character hashed password but still the problem continues.....The connection obviously occurs because the login window appears, But when the username and password are entered, the query dies and the user is returned to the login page.pytrin wrote:generate a new password or reset it for your main user. if you can't do it yourself, ask your provider to do it for youI Know the password hashing algorithm has changed
Any more thoughts???
gilk9