+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: problem mysql connection (/showthread.php?tid=2417)
- WorldOfWars - 09-10-2013
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 - 09-10-2013
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 - 09-10-2013
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 - 09-10-2013
navicat , console and paste
- WorldOfWars - 09-10-2013
I found, now work.
Thanks at @2 and @2 .
SOLVED
- fonsy84 - 09-10-2013
please rename post and put SOLVED , thx
- Paramount - 09-10-2013
Closed and moved.