Use MySQL-Client in Ubuntu to connect to MySQL-Server in XAMPP

XAMPP is green and will not be automatically started upon startup. Even in Linux, I still like green software. First, install MySQL-Client: sudoapt-getinstallmysql-client in Ubuntu to start mysql: sudo/opt/lampp/lamppstartmysql in XAMPP. If you connect directly, the error "Can't connect to localmy" will be reported.

XAMPP is green and will not be automatically started upon startup. Even in Linux, I still like green software.

First install MySQL-Client in Ubuntu:

Sudo apt-get install mysql-client

Start mysql in XAMPP:

Sudo/opt/lampp startmysql

If you connect directly, an error is returned:

Can't connect to local MySQL server through socket '/var/run/mysqld. sock' (2)

Solution:

Sudo mkdir/var/run/mysqld

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

Reconnect:

Mysql-u root-p

The connection is connected and the problem is solved.