Troubleshooting of MySQL errors: Difference between revisions

Troubleshooting of MySQL errors (edit)

617 bytes removed , 12 May 2024

14,953

edits

@@ Line 164: / Line 164: @@
 * [http://dev.mysql.com/doc/refman/5.7/en/set-password.html MySQL :: MySQL 5.7 Reference Manual :: 14.7.1.7 SET PASSWORD Syntax]
 * [http://dev.mysql.com/doc/refman/5.7/en/drop-user.html MySQL :: MySQL 5.7 Reference Manual :: 14.7.1.3 DROP USER Syntax]
-== 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.
 == Database and Table Operation Errors ==