Connecting to MySQL through Cygwin

Question

I have XAMPP running on my desktop and can connect to the MySQL server via phpMyAdmin. However, when I try to connect through Cygwin: Error: Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2) I've tried connecting to MySQL on the same machine, my local dev server and my remote server, all failed.

Accepted Answer

``` mysql -h 127.0.0.1 -P -u root -p ``` This is what worked for me. Make sure you check what is the correct port. Check the mysqld PID with: ``` ps -sW | grep mysqld ``` And then find the PORT with: ``` netstat -nao | grep ``` Have fun!

Connecting to MySQL through Cygwin

Solution

Problem