解决Linux MySQL报错ERROR 2002
来源:互联网 发布:猎场网络什么时候播出 编辑:程序博客网 时间:2024/06/14 00:45
在Linux安装MySQL有时候会出现[mysql]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 这样的错误,具体解决办法如下:
[root@www ~]# rm -rf /var/lib/mysql/*[root@www ~]# rm /var/lock/subsys/mysqldrm: remove regular empty file `/var/lock/subsys/mysqld'? y[root@www ~]# killall mysqld[root@www ~]# service mysqld start[root@www ~]# /etc/rc.d/init.d/mysqld statusmysqld (pid 5457) is running...
[root@r710-1 /]# mysql -u rootERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)[root@r710-1 /]# vi /etc/my.cnf##########添加如下内容:[client] socket=/var/lib/mysql/mysql.sock
##########保存退出后,##########重启mysql[root@r710-1 /]# service mysqld restartShutting down MySQL. [ OK ]Starting MySQL. [ OK ][root@r710-1 /]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)[root@r710-1 /]# mysql -u rootWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.1.45 MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;exitBye[root@r710-1 /]# mysql -u root -p原出处:http://www.linuxidc.com/Linux/2010-06/26890.htm
0 0
- 解决Linux MySQL报错ERROR 2002
- 解决Linux MySQL报错ERROR 2002
- 解决Linux MySQL报错ERROR 2002
- 解决Linux MySQL报错ERROR 2002
- 解决Linux MySQL报错ERROR 2002 (HY000)
- linux mysql 启动报错error:2002 '/tmp/mysql.sock'
- linux 下安装mysql 报错 解决
- Linux 下 Mysql error 2002 错误解决
- 解决MySql 报错:ERROR 1366 (HY000): Incorrect string value....
- mysql报ERROR 2003错误的解决
- (linux下windows下一样)mysql如何插入中文,解决插入中文报错,ERROR 1366 (HY000):Incorrect string value
- MySQL 启动报错-ERROR 2002 (HY000)
- linux登录MySQL,报错ERROR 1045 (28000)解决办法
- 【转】运行mysql报错ERROR 2002 (HY000): Can\'t connect to local MySQL server through socket[已解决]
- linux mysql安装,启动及报错解决
- Kali Linux启动mysql错误解决ERROR 2002 (HY000)
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql报错:ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'ych'解决方式
- Imageview
- 选择排序
- HTTP Header 详解
- Oracle字符集修改及用户密码永不过期处理
- Linux内核配置以及Make menuconfig过程分析
- 解决Linux MySQL报错ERROR 2002
- 快速网络netcat
- c#对网页进行全部截取的截图
- [OpenJudge] 2.5基本算法之搜索 红与黑
- mybatis使用resultType的时候,有的属性加载不出来
- 交换排序
- 结构体struct
- Caffe系列(11):数据可视化环境(python接口)配置
- Echarts3.0+Ajax请求数据柱状图实例