#2002 – No connection could be made because the target machine actively refused it.
The server is not responding (or the local server’s socket is not correctly configured).
Connection for controluser as defined in your configuration failed.
I restart the Apache and MySQL, the problem disappears. Btw, port is 3306, don’t need to change to 80.
If a database on MySQL couldn’t be deleted on phpMyAdmin, it could be deleted by deleting the database’s folder.
Go to C:\xampp\mysql\data
Then delete the folder of the database.
#1194 – Table ‘user’ is marked as crashed and should be repaired
then ran the command as below:
mysqlcheck –repair –all-databases
Then I can the “Users overview” on phpMyAdmin now.
Error: #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server （Windows）
Open the file my.ini in the folder： C:\xampp\mysql\bin, and add the line “skip-grant-tables” under “[mysqld]”, then reboot Apache and MySQL, now you can open phpMyAdmin to visit the database.