Under review

mysql login

Marty Miller-Crispe 11 years ago updated by Eugene Pankov (Project coordinator) 10 years ago 9

ERROR 1044 (42000) at line 1: Access denied for user 'username'@'localhost' to database 'mysql'

Where my 'username' is correct. From command line I can use mysql -p with the username and password configured in Ajenti.

I am new to Ajenti, just installed it rather than using webmin.

Are you trying to perform an operation on 'mysql' system database? Could it be that username doesn't have required GRANTs for that on server?

i installed Ajenti, configured the mysql options (the only options are to put username and password), then I click on the mysql module link to try to use it to administer mysql.  I just get the error as described.

I am sure I put in my authorisation details correctly as these work perfectly if I just use mysql from the command line or using webmin (for which I am trialling Ajenti as a replacement).  

Check whether your user is allowed to connect from localhost (as opposed to unix socket used by mysql utility).
How can I login to mysql as root from command prompt? what is the root password set by ajenti v?
Under review
Ajenti V doesn't set or change root password. You can login with mysql -uroot -pyourpassword
I tried to enter mysql -u root -p and then my root login password but it didn't work. Finally I have reset the root password!
You need to enter your MySQL root password, not system root password.
Thats what I am asking, where to get that?
You have set it during MySQL installation. It's possible to recover the password http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix