ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
2023-09-14 09:01:14 时间
[root@gaosheng ~]# mysql -uarcerzhang -parcerzhang -hlocalhost ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@gaosheng ~]# ll /var/lib/mysql/ total 20544 drwx------ 2 mysql mysql 4096 Apr 1 04:01 arcerdb drwx------ 2 mysql mysql 4096 Mar 31 22:34 billy -rw-rw---- 1 mysql mysql 10485760 Apr 1 03:56 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Apr 1 03:56 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Mar 30 23:07 ib_logfile1 drwx------ 2 mysql mysql 4096 Mar 31 23:32 meta drwx------ 2 mysql mysql 4096 Mar 30 23:07 mysql srwxrwxrwx 1 mysql mysql 0 Apr 1 03:56 mysql.sock drwx------ 2 mysql mysql 4096 Mar 30 23:07 test drwx------ 2 mysql mysql 4096 Mar 31 00:47 testdb [root@gaosheng ~]# /etc/init.d/mysqld start Starting MySQL: [ OK ] [root@gaosheng ~]# mysql -uarcerzhang -parcerzhang Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.77-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | arcerdb | | billy | | meta | | mysql | | test | | testdb | +--------------------+ 7 rows in set (0.07 sec) mysql>
相关文章
- MySQL基础知识——范式与事务
- mysql5.6采集数据插入出现MySQL server has gone away解决办法
- 【技巧总结】Penetration Test Engineer[5]-Operating System Security(SQL Server、MySQL提权)
- Mybatis+MySQL动态分页查询数据经典案例(含代码以及测试)
- centos用yum安装mysql-server
- mysql分享二-防止sql注入
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- Starting MySQL... ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
- Wing FTP Server与mysql数据库整合
- MySQL内核月报 2014.12-MySQL· 答疑释惑·server_id为0的Rotate
- MySQL · 参数故事 · innodb_additional_mem_pool_size
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- MySQL Join Buffer参数查询命令
- atitit。mssql sql server 转换mysql 及 分页sql ast的搭建
- ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
- 全网多种方法解决You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- tomcat链接mysql时超时报错java.io.EOFException: Can not read response from server. Expected to read 4 bytes,
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错:2006 - MySQL server has gone away
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server
- MySQL远程连接报错2003-cant connection to mysql server on ‘IP’(10061 unknown error)
- Mycat启动正常但无法连接ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql
- [ Azure - Database ] What the f**k is going on Azure Database for MySQL -- Single Server ?