strace 解决 mysql 连接数据库总是定位/tmp/mysql.sock的问题
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了strace 解决 mysql 连接数据库总是定位/tmp/mysql.sock的问题,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含1960字,纯文字阅读大概需要3分钟。
内容图文
查看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 ENOENT (No such file or directory)
stat("/usr/local/mysql/etc/my.cnf", {st_mode=S_IFREG|0644, st_size=3816, ...}) = 0
open("/usr/local/mysql/etc/my.cnf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=3816, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb9595ef000
read(3, "# For advice on how to change se"..., 4096) = 3816
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7fb9595ef000, 4096) = 0
stat("/root/.my.cnf", 0x7ffca8678640) = -1 ENOENT (No such file or directory)
stat("/root/.mylogin.cnf", {st_mode=S_IFREG|0600, st_size=504, ...}) = 0
open("/root/.mylogin.cnf", O_RDONLY) = 3
···
删除.mylogin.cnf文件
···
rm /root/.mylogin.cnf
rm: remove regular file ‘/root/.mylogin.cnf’? y
···
再次登录正常
···
#mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.26-log MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
···
内容总结
以上是互联网集市为您收集整理的strace 解决 mysql 连接数据库总是定位/tmp/mysql.sock的问题全部内容,希望文章能够帮你解决strace 解决 mysql 连接数据库总是定位/tmp/mysql.sock的问题所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。