+- 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: [Soldev]Problem start server files with password mysql (/showthread.php?tid=1716)
- axander - 03-29-2013
I have started server files ep2 with succes but i cant use in newstorm or in config files the password of user root because all files give me error to connect db, if i leave password, the server starting without problem! 1)The password i insert in newstorm is correct i can make connection with navicat without problem 2) i try to make another user and password, navicat connect ok server files no! Someone can help me?
- Wizatek - 03-29-2013
as long as the server doesnt have a webserver i dont think its bad to use no password for the localhost connection.
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
- axander - 03-30-2013
Thanks Wizatek solved problem with your guide, you are great^^!