Take the 2-minute tour ×

Installed MySQL - but not able to login with the user I created. It gives me the following error.

Access denied for user 'xxxxxx'@'localhost' (using passwo rd: YES)

Please help.

Thanks Prasad

share|improve this question
Can you still login to MySQL with root? –  Shutupsquare Jan 5 '13 at 16:01
How did you create the user? Is this user listed when you log in as root? Is this MySQL from regular Ubuntu packages? –  gertvdijk Jan 5 '13 at 18:14
add comment

1 Answer

up vote 0 down vote accepted

Simple solution is to login into mysql as a root user and grant privileges to other usernames.

mysql -u root -p

use the password, which you entered during the installation process.

grant all privileges on *.* to xxxxxxx@localhost identified by 'your_password_here' with grant option;

once this is done. You can login with your username using the command mysql -p

share|improve this answer
add comment

Your Answer


