关于centos6上用yum安装mysql后，出现的ERROR 2002 (HY000)的解决办法

最新推荐文章于 2022-08-30 15:49:12 发布

TruthK

最新推荐文章于 2022-08-30 15:49:12 发布

阅读量1.4k

点赞数

文章标签： mysql centos

我在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：

然后就可以用 mysql -u root -p ;进入Mysql了。

ps:操作系统centos6.6(以前没有安装过mysql)，在谷歌上每个人解决ERROR 2002 (HY000)的方法都不一，所以希望我的解决方法，帮上你。

如有不对,还望大佬们多多指教.我的博客园点击打开链接