- open http://localhost/phpmyadmin/
- then chose tab "SQL"
- Now type the following query in the textarea and click Go
UPDATE mysql.user SET Password=PASSWORD('yourpassword') WHERE User='root'; FLUSH PRIVILEGES;
- And you will see a message saying that the query has been executed successfully
Next step you need to modify the phpMyAdmin config file (config.inc.php), coz if you refresh the page, you will be getting a error message.
- Locate the file config.inc.php will be found in your XAMPP directory under the folder phpmyadmin (in my case, this is my dir XAMPP "D:\xampp\phpMyAdmin" )
- Open the file config.inc.php with your favorite text editor (I used notepad++).
- Find the following lines:
and replace value password and AllowNoPassword like this
- Save file
