Have encountered with cannot connect: invalid settings error. Then you’re going to solve this in few simple steps. This error will occur due to a crash of your MySQL user table. Let’s see how we can solve this.

Step 01: Go to XAMPP control panel

Step 02: Open my.ini under config of MySQL module

Step 03: Search for [mysqld] and add this text skip-grant-tables just after the searched text and save it and close the file. Your changes will look like below.

Step 04: Restart the MySQL server by stopping the current run and Starting again.

Step 05: Go the browser and reload the phpMyAdmin again or browse it again. Ex: localhost/phpmyadmin. Now you should be able to access the phpMyAdmin.

Step 06: Select and browse the tables of mysql database and check the user table. From the With selected  dropdown select Repair Table. It will take a while and you can see the status update in a while.

If it is success you can see mysql.user repair status OK

You’re done now. Thank you for reading this article about solving cannot connect invalid settings error. Hope you enjoyed and could able to get your phpMyAdmin right back. Happy learning ahead.

Recommended: Please follow our step by step guide how to create a WordPress Theme from scratch. You’ll be able to create your own theme at the end of these lessons.