Thursday, November 7, 2013

Simple way to solve MySql Error #1044 - Access denied for user 'username'@'localhost' to database 'my_database'

Error Description:

Access denied for user 'username'@'localhost' to database 'my_database' means: 
the user 'username' doesnot have enough or no privilege to access (insert, update, create, drop/delete) the database 'my_database'.

Simple Solution:

1. Create the database in cPanel
2. DONOT assign a user [Main thing]

3. Use phpMyAdmin -> Select the database you want to import the tables -> Go to Import tab and browse for the file -> Click "Go"

4. You will see "Import has been successfully finished ..." message.