[Solved]Can't connect to [local] MySQL server in Linux

[Jasmine-liang]

Check the MYSQL Reference Manual

MySQL :: MySQL 5.6 Reference Manual :: B.3.2.2 Can't connect to [local] MySQL server
I know there are two ways of connecting the mysqld server in Unix, So I quckly found that the /tmp/mysql.sock was missing.

Solution

資料庫中mysql.sock不存在問題，Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) " - IT閱讀
Then use systemctl start mysqld.service to start the server.
Use systemctl status mysqld.service to check the status of the server.

[Jasmine-liang]

[Jasmine-liang]

Solution:
ln -s /var/lib/mysql/mysql.sock /run/mysqld/mysqld.sock


Start MySql:

  systemctl start mysqld.service
  mysql -u root -p