Mysql-client ERROR 2002 Workaround

Host Environment: Debian 8

Development environment: XAMPP

Install Mysql-client:

#apt-get Install Mysql-client

Start the XAMPP MySQL environment:

#/opt/lampp/./lampp Startmysql

Connection MySQL will report 2002 error:

ERROR 2002:can ' t connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock ' (2)

Workaround:

sudo mkdir/var/run/mysqld

sudo ln-s/opt/lampp/var/mysql/mysql.sock/var/run/mysqld/mysqld.sock

Then use mysql-client to connect:

Mysql-hlocalhost-uroot-p

However, after the computer restarts the soft connection created above will disappear, each time to re-create it will be very cumbersome, so you can add the above software Connection command in the/etc/rc.local file can be solved perfectly

Mysql-client ERROR 2002 Workaround