Mysql showing error on console/phpmyadmin : ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'test123'

Question

Not able to create,drop database from phpmyadmin or mysql command line. It showing error:

  "ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'test123'"

After googling i found that to grant the permission to user using the command:

  GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
  FLUSH PRIVILEGES;

But it also giving the error as mentioned above.

I have also uninstall and install the mysql and phpmyadmin again in the system but still getting same error's.

Please advice.

mysql>show grants;

 +--------------+
 | Grants for root@localhost                                                         |
 +------------------------------------+
 | GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD    <secret>      |
 | GRANT ALL PRIVILEGES ON `oe_school`.* TO 'root'@'localhost' WITH GRANT OPTION |

+-----------------------------------------------+

http://stackoverflow.com/questions/8838777/error-1044-42000-access-denied-for-user-localhost-to-database-db try this link. I'm not sure may be help you. — Syed mohamed aladeen, Aug 21 '15 at 05:58
Probably the password is wrong or the order of arguments in the way you try to connect is wrong. — Hassan Althaf, Aug 21 '15 at 06:04
when i run the show grants command it show the above result. — Mohd Bashir, Aug 21 '15 at 06:06
root has no privilege to create something ("GRANT USAGE ..."), it only has privelege `ALL` on the database `oe_school` — Axel Amthor, Aug 21 '15 at 06:16
@mohd try this command line, it will run the configuration process and let you set the passwords again. `sudo dpkg-reconfigure mysql-server-x.x` — mdamia, Aug 22 '15 at 02:27

score 0 · Answer 1 · answered Aug 24 '15 at 09:38

Finally i solved issue it to uninstall MYSQL and also delete the Mysql folder.

 sudo apt-get remove --purge mysql-server mysql-client mysql-common
 sudo apt-get autoremove
 sudo apt-get autoclean
 sudo rm -rf /var/lib/mysql

Mysql showing error on console/phpmyadmin : ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'test123'

1 Answers1