1. General
  2. Questions
0
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.

Eugene Pankov (Project coordinator) 11 years ago

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?

Marty Miller-Crispe 11 years ago

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).  


Eugene Pankov (Project coordinator) 10 years ago
Check whether your user is allowed to connect from localhost (as opposed to unix socket used by mysql utility).
happyhardik 10 years ago
How can I login to mysql as root from command prompt? what is the root password set by ajenti v?
Under review
Eugene Pankov (Project coordinator) 10 years ago
Ajenti V doesn't set or change root password. You can login with mysql -uroot -pyourpassword
+1
happyhardik 10 years ago
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!
Eugene Pankov (Project coordinator) 10 years ago
You need to enter your MySQL root password, not system root password.
happyhardik 10 years ago
Thats what I am asking, where to get that?
Eugene Pankov (Project coordinator) 10 years ago
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

Customer support service by UserEcho