ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
2024-10-17 12:10:20
从供应商手中接手一个云平台(Windwos Azure)上的MySQL数据库,登录数据库时遇到错误:
$mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
检查配置文件/etc/my.cnf发现供应商修改了mysql数据库的数据存储目录,另外mysql.sock文件位置也变更为了/dat/data/mysql/mysql.sock
$ more /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
innodb_buffer_pool_size = 2048M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/dat/data/mysql
socket=/dat/data/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
检查发现/var/lib/mysql/mysql.sock文件不存在,可以通过建立mysql.sock文件的软连接。然后登录数据库,问题解决。
[root@GETAZLNX005 ~]# ls /var/lib/mysql/mysql.sock
ls: cannot access /var/lib/mysql.sock: No such file or director
[root@GETAZLNX005 ~]# ln -s /dat/data/mysql/mysql.sock /var/lib/mysql/mysql.sock
最新文章
- HOJ 1640 Mobile Phone
- C++简单使用Jsoncpp来读取写入json文件
- LRU Cache的实现
- 获取用户ip接口
- Dynamics CRM 导入用户数据错误 could not retrieve salesperson role
- nodejs搭建web服务器
- Elasticsearch之删除索引
- tensorflow激励函数-【老鱼学tensorflow】
- sqli-labs第一节 get-字符型注入
- Codeforces Gym100187C Very Spacious Office 贪心 堆
- ef学习一
- makefile中的wildcard和notdir和patsubst
- django 运行脚本
- JDK自带线程池介绍及使用环境
- 荣耀 6 安装 SD 卡,提示:SD卡已安全移除
- 利用blob对象实现大文件分片上传
- 心灵鸡汤[all]
- php-redis 模块 文档
- [转]Creating an OData v3 Endpoint with Web API 2
- Servlet------>;mvc模式原理图
热门文章
- 【记录】ASP.NET MVC 4/5 Authentication 身份验证无效
- android UI 仿 win 8 模块化 标题,并实现 可长按拖动交换图片位置、可点击,且伴随动画特效
- Oracle Database Server 'TNS Listener'远程数据投毒漏洞(CVE-2012-1675)解决
- Struts2环境下Tomcat启动异常:Exception starting filter struts2,报了一个java.lang.ClassNotFoundException
- 你想不到的!CSS 实现的各种球体效果【附在线演示】
- (十五)WebGIS中平移功能的设计和实现
- PHP运行及语句
- Fragment基础----创建
- 在Navicat premium上创建的SQL Server数据库,实现用PHP连接(即php连接微软MSSQL)
- Hexo折腾记