phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin

by

If you’re getting the #2002 Cannot log in to the MySQL server error while logging in to phpmyadmin, try editing phpmyadmin/config.inc.php and change:

$cfg['Servers'][$i]['host'] = 'localhost';

to:

$cfg['Servers'][$i]['host'] = '127.0.0.1';

Solution from Ryan’s blog

Edit (20-Mar-2015):

Note that if you’re on a fresh install, config.inc.php may not exist. You need to rename / copy config.sample.inc.php and then change the relevant line

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. If two columns are 1 then make new column
  3. MySQL: How to reset or change the MySQL root password?
  4. How to display UTF-8 characters in phpMyAdmin?
  5. #1071 – Specified key was too long; max key length is 1000 bytes
  6. MySQL : isn’t in GROUP BY
  7. MySQL: Can’t create table (errno: 150)
  8. Restore table structure from frm and ibd files
  9. Subqueries with EXISTS vs IN – MySQL
  10. phpMyAdmin on MySQL 8.0 [duplicate]
  11. Setting up foreign keys in phpMyAdmin?
  12. How to access remote server with local phpMyAdmin client?
  13. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  14. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  15. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  16. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  17. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  18. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  19. How to Import Multiple csv files into a MySQL Database
  20. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  21. Can’t import database through phpmyadmin file size too large
  22. Access denied after setting user’s password with SHA256 in phpMyAdmin
  23. SQL: deleting tables with prefix
  24. where does MySQL store database files?
  25. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  26. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  27. How do I write an SP in phpMyAdmin (MySQL)?
  28. How to import large sql file in phpmyadmin
  29. How to get back Lost phpMyAdmin Password, XAMPP
  30. UTF8 problem with MySQL 5

Leave a Comment