phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out

by

Go inside your phpMyAdmin directory inside XAMPP installation folder. There will be a file called config.inc.php. Inside that file, find this line:

$cfg['Servers'][$i]['password'] = '';

you must make sure that this field has your mysql root password (the one that you set).

More Related Contents:

  1. If two columns are 1 then make new column
  2. MySQL: How to reset or change the MySQL root password?
  3. MySQL Server has gone away when importing large sql file
  4. #1071 – Specified key was too long; max key length is 1000 bytes
  5. MySQL : isn’t in GROUP BY
  6. MySQL: Can’t create table (errno: 150)
  7. Why is the estimated rows count very different in phpmyadmin results?
  8. MySQL user DB does not have password columns – Installing MySQL on OSX
  9. phpMyAdmin on MySQL 8.0 [duplicate]
  10. Setting up foreign keys in phpMyAdmin?
  11. How to access remote server with local phpMyAdmin client?
  12. MySQL root password change
  13. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  14. mysql root password forgotten
  15. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  16. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  17. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  18. How to reset the root password in MySQL 8.0.11?
  19. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  20. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  21. How to Import Multiple csv files into a MySQL Database
  22. Composite key as foreign key (sql)
  23. Can’t import database through phpmyadmin file size too large
  24. Access denied after setting user’s password with SHA256 in phpMyAdmin
  25. SQL: deleting tables with prefix
  26. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How do I write an SP in phpMyAdmin (MySQL)?
  29. How to import large sql file in phpmyadmin
  30. Import CSV to Update rows in table

Leave a Comment