strace查看mysql建立连接_strace 解决 mysql 连接数据库总是定位/tmp/mysql.sock的问题...

查看mysqld和mysql默认读取my.cnf的顺序

···

mysql --help --verbose | grep ‘my.cnf‘

order of preference, my.cnf, $MYSQL_TCP_PORT,

/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

mysqld --verbose --help | grep ‘my.cnf‘

/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default

···

报错的表现

···

mysql

ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)

···

stace mysql 命令的执行过程

···

strace /usr/local/mysql/bin/mysql

execve("/usr/local/mysql/bin/mysql", ["/usr/local/mysql/bin/mysql"], [/21 vars/]) = 0

= 0

stat("/etc/my.cnf", 0x7ffca8678640) = -1 ENOENT (No such file or directory)

stat("/etc/mysql/my.cnf", 0x7ffca8678640) = -1