Shulou(Shulou.com)05/31 Report--

This article mainly introduces "Fedora8 startup error report ERROR 2002 (HY000) how to solve". In daily operation, I believe many people have doubts about how to solve the problem in Fedora8 startup error report ERROR 2002 (HY000). The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "Fedora8 startup error report ERROR 2002 (HY000) how to solve". Next, please follow the editor to study!

Fedora8 startup error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/ var/lib/mysql/mysql.sock' (2)

1. Check / etc/rc.d/init.d/mysqld status first to see if mysql has been started.

In addition, let's see if it's a question of authority.

2. Make sure your mysql.sock is in that position.

Mysql-u your mysql user name-p-S / var/lib/mysql/mysql.sock

3. Try: service mysqld start

4. If it is a permission problem, change the permission # chown-R mysql:mysql / var/lib/mysql first.

[root@localhost ~] # / etc/init.d/mysqld start

Start MySQL: [OK]

[root@localhost] # mysql-uroot-p

ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/ var/lib/mysql/mysql.sock' (2)

The reason is that there is a problem with access to / var/lib/mysql.

Shell > chown-R mysql:mysql / var/lib/mysql

Then start the server

Shell > / etc/init.d/mysql start

The mysql.sock file is automatically generated by viewing / var/lib/mysql after the server starts normally.

But my problem still hasn't been solved.

The problem is finally solved:

Method: modify / etc/my.conf:

[mysqld]

Datadir=/usr/local/mysql/data

Socket=/var/lib/mysql/mysql.sock

[mysql.server]

User=mysql

Basedir=/usr/local/mysql

If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:

[client]

Socket=/var/lib/mysql/mysql.sock

Found that this is still the case, run / etc/init.d/mysql start error: Starting MySQLCouldn't find MySQL manager or server

The mysqld service is not started, run / usr/local/mysql/bin/mysqld_safe &

Problem solved.

At this point, the study on "Fedora8 startup error ERROR 2002 (HY000) how to solve" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.