Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
如何解决？
-
[root@linuxServer ~]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
如何解决？
展开阅读全文
-
等级
本版专家分：5812勋章
-
- 黄花 2009年9月 其他数据库开发大版内专家分月排行榜第二
-
-
问题是远程连接没问题 本体连接登陆则出现该问题 也无法重启mysql服务
-
等级
本版专家分：552 -
mysql --protocol=TCP -uroot -p -P3306 -hlocalhost
试试看
-
等级
本版专家分：5812勋章
-
- 黄花 2009年9月 其他数据库开发大版内专家分月排行榜第二
-
-
问题解决了
1.#ps -A|grep mysql
显示类似：
1829 ? 00:00:00 mysqld_safe
1876 ? 00:00:31 mysqld
2.#kill -9 1829
3.#kill -9 1876
4.#/etc/init.d/mysql restart
5.#mysql -u root -p
-
等级
本版专家分：472941勋章
-
- 名人 2012年 荣获名人称号
-
- 榜眼 2010年 总版技术专家分年内排行榜第二
-
- 探花 2009年 总版技术专家分年内排行榜第三
-
-
进士
2013年 总版技术专家分年内排行榜第十
2011年 总版技术专家分年内排行榜第七
-
-
启了两个MYSQL服务？
-
等级
本版专家分：6536勋章
-
-
微软MVP
2011年7月 荣获微软MVP称号
2010年7月 荣获微软MVP称号
-
-
红花
2009年8月 MS-SQL Server大版内专家分月排行榜第一
2009年7月 MS-SQL Server大版内专家分月排行榜第一
-
- 黄花 2010年8月 其他数据库开发大版内专家分月排行榜第二
-
-
直接指定端口号可以么？
-
等级
本版专家分：1658 -
问题是远程连接没问题
-
等级
本版专家分：5812勋章
-
- 黄花 2009年9月 其他数据库开发大版内专家分月排行榜第二
-
-
新问题又出来了
mysql> show grants for 'nian.zhang' \G;
*************************** 1. row ***************************
Grants for nian.zhang@%: GRANT SELECT, UPDATE, DELETE, CREATE, DROP, INDEX, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'nian.zhang'@'%' IDENTIFIED BY PASSWORD '*5CCE2565AAAC88BA466E2EC67E7362AA8C050981'
1 row in set (0.00 sec)
我给远程用户授予权限了
可是还是登陆不上去 查看log
100920 11:51:53 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'on.000001' at postion 357
100920 11:51:53 [ERROR] Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation ( server_errno=1227)
这是为什么?
-
等级
本版专家分：5812勋章
-
- 黄花 2009年9月 其他数据库开发大版内专家分月排行榜第二
-
-
我用root 用户也说没有权限啊 why？
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| root@% |
+----------------+
1 row in set (0.01 sec)
mysql> show binary logs;
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
-
等级
本版专家分：552
-
你的socket文件丢失了吧
mysql --protocol=TCP -uroot -p -P3306 -hlocalhost
这个试过了么？
-
等级
本版专家分：5812勋章
-
- 黄花 2009年9月 其他数据库开发大版内专家分月排行榜第二
-
-
[root@linuxServer etc]# mysql --protocol=TCP -uroot -p -P3306 -hlocalhost
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 184
Server version: 5.1.31-community-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
没问题
- mysql连接错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket...
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) 错误原因：连接mysql是通过socket配置文件进行连接,这个错误是连接MySQL找不到这个mysql.sock文件...
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' 该问题十分有效地解决方案： $ mysql -u root -p 出现上述问题，mysql数据库连接不上。 $ mysql -h ...
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket 解决办法
故障描述：启动mysql 报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)1.先查看mysql启动状态#/etc/rc.d/init.d/mysqld status2.mysql.sock位置...
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'...
今天服务器遇到了一个很熟悉的问题 输入#mysql -u root -p ERROR 2002 (HY000):Cant connect to local MySQL server 随即上网找寻答案 根据大家提供的方法我逐一尝试 方案1. 1.#ps -A|grep mysql 显示类似： ...
- ERROR 2002 (HY000): Cant connect to local MySQL server through socket的解决方法
连接MySQL提示ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/my...
- ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock...
记录一个Linux 版本Mysql的常见的错误，在网上看到了很多关于...ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@server2 ~]# chown -R mysql:mysql /
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
在安装好了MySQL之后，使用了新的配置文件后，MySQL服务器可以成功启动，但在登陆的时候出现了ERROR 2002 (HY000): Can't connect to local MySQL server through socket，即无法通过socket连接到mysql服务器，同时...
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Mysql连接错误提示：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 方案： 使用：ps -ef|grep mysql （查看mysql进程）-- 查看是否有多余进程 ...
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了 在centos7以后 就变成了mariadb 所以 启动systemctl restart mariadb 一般情狂下 就可以啦 例如: CREATE USER ...
- 解决 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
亲测有效 ...ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) 好吧，很明显是mysql.sock文件找不到了，这个文件以前在/tmp 下现在没有了，那么...
- 解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
今天想登陆下mysql查询一下数据，结果发现客户端连接不上，报错提示：2003-Can...)，然后进入到linux 里的mysql，一样连接不上， 报错提示：解决ERROR 2002 (HY000): Can't connect to local MySQL server through s...
- Ubuntu 18.04访问MySQL出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/...
因为太久没用 mysql 登录时显示错误 ERROR 2002 (HY000): Can’t connect to local MySQL server through socket '/var 解决方法：安装 mysql-server sudo apt install mysql-server
- linux启动mysql 出现RROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run...
问题出现的原因，是我关闭了MySQL，而且是所有关于MySQL的进程都关闭了，这是问题出现的原因。...ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so
- MYSQL之ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
登陆时遇到错误：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 解决： $ /etc/init.d/mysql.server restart [ ok ] Restarting mysql.server (via systemctl)...
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysq 今天在linux里安装mysql，运行时遇到这样的错误 ERROR 2002 (HY000): Can't connect to local MySQL ...
- MySQL错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket
1、故障现象 [root@SZDB mysqldata]# mysql -uroot -p123456 Warning: Using a password on the command line interface can be ...ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- Linux上mysql登陆错误解决办法ERROR 2002 (HY000): Can't connect to local MySQL server through socket '...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 解决方法： 1：首先确认你在root权限下 [root@localhost tmp]# mysql -u root -p Enter password...
- MySql 报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' ...
MySql 报错ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 这个错是链接时报的错，要链接必须启动。修复的时候首先要启动mysql。 首先来了解一下 mysql.sock的...
- ubuntu登录mysql报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/...
错误信息： ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) 我这的原因是没有开启mysql。 sudo service mysql start 即可。 ...
- linux安装MySQL后输入mysql显示 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
我是小白，大佬勿喷 ...ERROR 2002 (HY000): Can't connect to local MySQL server through socket 解决办法 输入service mysql restart root@DES:/# service mysql restart * Stopping MySQL database serve...
- CentOS下安装mysql和解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/...
centos7安装mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 1、启动mysql 初始密码在less mysqld.log文件里找，关键词是password 赋权给远程访问 登陆数据库 ...
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)解决方法
Linux下登录mysql是出现这样的问题ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 首先查看一下mysql运行情况 systemctl status mysqld 这就表明mysql没有处于...
- Linux ERROR 2002 (HY000): Can't connect to local MySQL server through socket和 Couldn't find MySQL ...
Linux环境，通过mysql -uroot -p命令进入mysql的时候，总是报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket 通过service mysqld restart 重启mysql，也是报错“ Couldn't find MySQL...
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysq.sock' (2)
使用mysql -u root报ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysq.sock’ (2) 打开mysql的日志：（/var/log/mysqld.log)看到了[ERROR] /usr/sbin/mysqld: unk...
- Mac上MySQL报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql....
mysql -uroot -p ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ 这种错误是因为不能通过socket文件连接mysql服务器，先说解决方案，有两种： 1、执行 sudo ln -s ...