Troubleshooting of socket connection errors in MySQL in Linux

A problem solved by PHP: (The problem that cannot be found by the socket file)

For this problem, baidu has a big copy! You have to worry about some problems ~~ As for the answers, they are of course the way to solve the problem. You can refer to them! However, some answers are irrelevant to this question, so you will not get the expected results if you use them!

Analyze the wrong direction. Do not rush to the doctor!

I installed lampp in the opt directory and run the mysql-u root-p command on the premise that all services are started: the following error occurs:

‍

First, lampp is installed in the opt directory, the mysql. the sock file is stored in/opt/lampp/var/mysql. in sock, it is not in/var/lib/mysql. sock

In this case, you can‍/Opt/lampp/var/mysql. sock:

Ln-s‍/Opt/lampp/var/mysql. sock‍/Var/lib/mysql. sock

The solution is as follows:

‍

----- Angela learning!