[Soldev]Problem start server files with password mysql

[axander]

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]

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]

Thanks Wizatek solved problem with your guide, you are great^^!