14,953
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Connection and Network Errors
| Line 394: | Line 394: | ||
Solution: [https://stackoverflow.com/questions/10317974/mysql-php-error2002-only-one-usage-of-each-socket-address-protocol-network-a MySQL/PHP Error:(2002) Only one usage of each socket address (protocol/network address/port) is normally permitted - Stack Overflow] | Solution: [https://stackoverflow.com/questions/10317974/mysql-php-error2002-only-one-usage-of-each-socket-address-protocol-network-a MySQL/PHP Error:(2002) Only one usage of each socket address (protocol/network address/port) is normally permitted - Stack Overflow] | ||
=== ERROR 2002: Cannot connect: SQLSTATE[HY000] [2002] === | |||
Condition on Cygwin terminal of Windows: | |||
<pre> | |||
$ mysql -u root -p | |||
Enter password: | |||
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2) | |||
$ mysql -h localhost -u root -p | |||
Enter password: | |||
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2) | |||
</pre> | |||
Solution: | |||
* Change {{kbd | key=<nowiki>-h localhost</nowiki>}} to {{kbd | key=<nowiki>-h 127.0.0.1</nowiki>}} | |||
<pre> | |||
$ mysql -h 127.0.0.1 -u root -p | |||
</pre> | |||
* If still not work, reboot the server and restart the MySQL service. | |||
== Resource and Environmental Errors == | == Resource and Environmental Errors == | ||