首页 > 数据库 >解决 Can't connect to local MySQL server through socket '/tmp/mysql.sock'

解决 Can't connect to local MySQL server through socket '/tmp/mysql.sock'

时间:2022-11-08 14:14:31浏览次数:35  
标签:tmp socket mysql sock ansible MySQL root

[root@localhost ansible-pandora]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[root@localhost ansible-pandora]# find / -name *.sock
/run/rpcbind.sock
/mysql_data/3306/mysql.sock
[root@localhost ansible-pandora]# ln /mysql_data/3306/mysql.sock /tmp/mysql.sock
[root@localhost ansible-pandora]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.39-log MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

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.

mysql>

 

标签:tmp,socket,mysql,sock,ansible,MySQL,root
From: https://www.cnblogs.com/wutongxiaoyuyear/p/16869493.html

相关文章

  • MySQL安装
    一,下载选择社区版的,下载地址:https://dev.mysql.com/downloads/installer/ ,选择离线安装包  二,安装1,双击安装包文件,这里选择服务模式服务模式更稳定,支持的连接数......
  • Oracle、MySQL等数据库故障处理优质文章分享 | 10月汇总
    墨天轮社区于9月起持续举办【聊聊故障处理那些事儿】DBA专题征文活动,每月进行评优发奖,鼓励大家记录工作中遇到的数据库故障处理过程,不仅用于自我复盘与分析,同时也能帮助其......
  • 《高性能MySQL》第一章:MySQL架构与历史 读书笔记
    Chapter.1StructureandHistoryofMySQL1.1MySQLlogicalstructureMySQL逻辑架构如上图所示。最上层服务并非mysql独有,大部分基于网络的工具都有类似的C/S架构。第......
  • Sqlyog 连接Mysql数据库连错误: 错误号码2003
      首先是检查了虚拟机网络配置,发现可以ping通说明网络没有问题。dockerrun-p3306:3306--namemysql-v/mydata/mysql/log:/var/log/mysql-v/mydata/mysql/dat......
  • mysql更新某日期为随机日期
    过去的五百天内:SELECTdate_sub(now(),interval(SELECTFLOOR(RAND()*500))DAY)============================================================思路:使用date_add()......
  • mysql 日期查询sql语句
    --今天SELECT*FROM表名WHERETO_DAYS(时间字段名)=TO_DAYS(NOW());--昨天SELECT*FROM表名WHERETO_DAYS(NOW())-TO_DAYS(时间字段名)<=1;--本周SELECT......
  • linux 系统安装 mysql 或者 主从
    mysql-5.7.18-linux-glibc2.5安装1.检查所使用的linux下是否有安装过mysqlrpm-qa|grep-imysql2.删除安装过的mysqlrpm-emysql-5.7.18-linux-glibc2.5-x86_64--no......
  • mysql分区命令
    CREATETABLEt_vocality_message(VOCALITY_MESSAGE_IDint(50)unsignedNOTNULLAUTO_INCREMENTCOMMENT'文本消息ID',S_IDvarchar(50)DEFAULTNULLCOMMENT'录......
  • CentOS7安装MySQL5.5步骤
    一、检查当前系统是否安装过Mysqlrpm-qa|grep-imysql 如果出现了上图的东西,则需要删除MySQL1,删除相关应用yumremoveMySQL-client-5.5.40-1.linux2.6.x86_......
  • mysql创建数据库并指定字符集
    说明:以创建“wangzy_table”库为例。一、默认创建的数据库CREATEDATABASE`wangzy_table`;二、创建数据库并指定字符集CREATEDATABASE`wangzy_table`DEFAULT......