Hi Guys I dont know what I have done wrong I'm accessing phpmyadmin through xampp on windows 7, when i changed the password on root@local host it locked me out with this #1045 - Access denied for user 'root@localhost'@'localhost' (using password: YES) what do i need to do?

Recommended Answers

the username is usually 'root' not 'root@localhost'. You sure you got it right?

Jump to Post

All 2 Replies

Member Avatar

the username is usually 'root' not 'root@localhost'. You sure you got it right?

Try this

The easiest way is to use the security console, which you can access at http://localhost/security/ This console creates a password for the MySQL user root and adjusts the phpMyAdmin configuration.

Another approach is to configure it with the "XAMPP Shell" (command prompt). Open the shell and execute this command:

mysqladmin.exe -u root password secret

Let us know what failed or if it worked^^

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.