Home » Fix Mysql error – 2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)
Fix Mysql error – 2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)
Sometimes opening phpMyAdmin can give below error due to incorrect setting done somehow. “2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)“ To FIx this run mysqld-debug.exe and then check phpmyadmin. mysqld-debug.exe path in xampp is your path-to-xamppmysqlbin. like C:xamppmysqlbinmysqld-debug.exe
Some times MySQL fails to start/restart with an error like "Plugin 'InnoDB' registration as a STORAGE ENGINE failed" The simple solution to fix is to delete InnoDB log files "ib_logfile0" and "ib_logfile1". Steps to delete above mentioned files The files "ib_logfile0" and "ib_logfile1" usually reside in the data directory in…
If enabling "Automatically Start MySQL Server on Startup" does not work then doing below process will fix it. Open terminal/command line interface (CLI) and run below commands. run "sudo vi /Library/LaunchDaemons/com.mysql.mysql.plist" and add below code and save the file. If vi does not work then create file "com.mysql.mysql.plist" in "/Library/LaunchDaemons/"…
For cases where an application fails to close a connection it is no longer using, a low wait_timeout value can help to avoid hitting max_connections simply due to sleeping idle connections that are not in a transaction and will not be reused. wait_timeout: is a variable representing the amount of time…