Phpmyadmin #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Error:

Solution:

1. Click on MySQL Console.

2. Change the Database : use MySQL;

3. Set your MySQL password with the following command,
UPDATE mysql.user SET Password=PASSWORD("EnterYourPasswordHere") WHERE User="root";
4. Press Enter.

5. Flush the privileges by typing: 
FLUSH PRIVILEGES;
Example:



Exit Console.

1. Open config.inc.php file in the phpmyadmin directory

2. Find line 21: $cfg['Servers'][$i]['password'] = ''

3. Change the Password

4. Restart XAMPP

Post a Comment

0 Comments