我在centos上用 yum install mysql,安装后出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'。随后我谷歌了一下,有人说是mysql-server没有装上,然后我就运行yum intsall mysql-server;然额并没有什么卵用。我就把关于mysql的都卸载了(yum remove mysql*),在装上mysql全家桶(yum install mysql*),还是出现了
RROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
。这时我再次谷歌,成功解决。
方法:先运行
service mysqld status
mysqld 已停
发现了mysqld服务停止,所以我们就要启动mysqld。
service mysqld start
出现结果
service mysqld start
初始化 MySQL 数据库: Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h redis password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
[确定]
正在启动 mysqld:
View Code
然后 就可以用 mysql -u root -p ;进入Mysql了。
ps:操作系统centos6.6(以前没有安装过mysql),在谷歌上每个人解决ERROR 2002 (HY000)的方法都不一,所以希望我的解决方法,帮上你。