Wednesday, September 20, 2017

[MySQL][Resolved] find out your unix socket

login your  mysql usig root permission , command :
mysql -u root -p
and then paste this sql to find it out :
show variables like '%sock%';
then you will found there is a variable_name named socket and a value "/var/lib/mysql/mysql.sock" was stored there, in this case, /var/lib/mysql/mysql.sock is the unix socket.

Beware that your socket location maybe different.

No comments :

Post a Comment