Access denied for user ‘root’@’localhost’ with PHPMyAdmin

by

Edit your phpmyadmin config.inc.php file and if you have Password, insert that in front of Password in following code:

$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '**your-root-username**';
$cfg['Servers'][$i]['password'] = '**root-password**';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

More Related Contents:

  1. WAMP/MySQL errors not in correct language
  2. Can I store query result of one field into different variables? if not then what should I do for that?
  3. The requested URL was not found on this server.
  4. Project Links do not work on Wamp Server
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. WAMP Cannot access on local network 403 Forbidden
  7. How to write a stored procedure using phpmyadmin and how to use it through php?
  8. Import file size limit in PHPMyAdmin
  9. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  10. Mysql event error using php
  11. Store procedures in phpMyAdmin
  12. How to solve time out in phpmyadmin?
  13. phpmyadmin automatic logout time
  14. WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded
  15. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  16. Unknown database error in PHP but it exists in PHPMyAdmin
  17. Extension mysqli is missing, phpmyadmin doesn’t work
  18. How to SELECT DEFAULT value of a field
  19. How to log in to phpMyAdmin with WAMP, what is the username and password?
  20. Auto Increment skipping numbers?
  21. How to write a stored procedure in phpMyAdmin?
  22. Installing PDO driver on MySQL Linux server
  23. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  24. Check if MySQL table exists or not [duplicate]
  25. PDO Cannot execute queries while other unbuffered queries are active
  26. PHP prepared statements and transactions in a loop [duplicate]
  27. save html-formatted text to database
  28. Should I disable MySQL strict mode?
  29. Using PDO Prepared Statement and Incrementing a column value
  30. Displaying BLOB image from Mysql database into dynamic div in html

Leave a Comment