03-29-2013, 04:28 PM
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

