problem mysql connection

[WorldOfWars]

Hey guys,

 

i got a new host and i want more security , so i added a password for the "root" user of mysql. I can connect to database via SSH, but when i want to start my Subhelper or other, i got message : cannot connect DB !! (i changed the pass in newstobm.bin too)

 

I changed the right of user in navicat ,they got all rights but he dont want to work.

 

Thanks for help.

[fonsy84]

Lastchaos is using a mysql library that only supports old passwords.

So u would have to enable the old passwords in /etc/my.cnf add the line old_passwords=1

and then restart mysql.

 

then u need to update the password for that user with a old password like this

UPDATE mysql.user SET password = OLD_PASSWORD(password comes here) WHERE user = root AND host = localhost

 

Now u can use the password 

 

by Wizatek

[WorldOfWars]

hey,

 

where i put it ?

 

UPDATE mysql.user SET password = OLD_PASSWORD(password comes here) WHERE user = root AND host = localhost

 

in navicat console or putty?

[fonsy84]

navicat , console and paste 

[WorldOfWars]

I found, now work.

 

Thanks at @2 and @2 .

 

SOLVED

[fonsy84]

please rename post and put SOLVED , thx

[Paramount]

Closed and moved.