今天,突然无法连接mysql了(我的本机当服务器和客户机)。
在shell中,
pt@pt-laptop:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
pt@pt-laptop:~$ sudo mkdir /var/run/mysqld/
[sudo] password for pt:
pt@pt-laptop:~$ sudo touch /var/run/mysqld/mysqld.sock
pt@pt-laptop:~$ sudo chown -R mysql /var/run/mysqld/
pt@pt-laptop:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)
pt@pt-laptop:~$
在查询浏览器中,
Could not connect to host '127.0.0.1'.
MySQL Error Nr. 2003
Can't connect to MySQL server on '127.0.0.1' (111)Click the 'Ping' button to see if there is a networking problem.
请问,如何解决?
在shell中,
pt@pt-laptop:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
pt@pt-laptop:~$ sudo mkdir /var/run/mysqld/
[sudo] password for pt:
pt@pt-laptop:~$ sudo touch /var/run/mysqld/mysqld.sock
pt@pt-laptop:~$ sudo chown -R mysql /var/run/mysqld/
pt@pt-laptop:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)
pt@pt-laptop:~$
在查询浏览器中,
Could not connect to host '127.0.0.1'.
MySQL Error Nr. 2003
Can't connect to MySQL server on '127.0.0.1' (111)Click the 'Ping' button to see if there is a networking problem.
请问,如何解决?
解决方案 »
- 请教大家一个基础问题:图片是怎么在数据库中保存的啊?
- 用个sql请大家帮忙
- MySQL的一个基础问题:为什么不能用?
- 实时加载数据库数据的问题
- 无题
- MySAL: Can't connect to MySQL server on 'localhost' (10061)
- 使用mysql migration toolkit将oracle迁移到mysql时出现innodb system error22
- 关于 mysql_fetch系列函数 的比较傻的问题
- 如何通过数据库中的值来查询字段?
- ODBC连接MySQL异常:未发现数据源名称并且未指定默认驱动程序
- 求一个随机取N条不重复数据的SQL语句
- Mysql有象Foxpro一样的浏览模式吗?
[收集]mysql 无法联接故障现象及原因