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?
stokie-rich 4 Junior Poster
diafol
the username is usually 'root' not 'root@localhost'. You sure you got it right?
Fernando_4 0 Junior Poster in Training
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.