Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' workaround + Linux start/stop/restart MySQL database method

Start MySQL Error:

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

1. Check the/ETC/RC.D/INIT.D/MYSQLD status first to see if M y S Q L has been started.
Also see if it is a permission issue.

2. Determine if 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 permissions first #chown-R mysql:mysql/var/lib/mysql

[[email protected] ~]#/etc/init.d/mysqld start
Start MySQL: [OK]
[Email protected] ~]# mysql-uroot-p

ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)
The reason for this is that the/var/lib/mysql access rights issue.

Shell> Chown-r Mysql:mysql/var/lib/mysql

Then start the server

Shell>/etc/init.d/mysql Start

After the server starts normally, look/var/lib/mysql automatically generate Mysql.sock files.

But my problem is still unresolved.

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 still so, run /etc/init.d/mysql start error: Starting mysqlcouldn ' t find MySQL manager or server
Is the MYSQLD service is not restarted, run/usr/local/mysql/bin/mysqld_safe &

Problem solving.

Start method

1. View MySQL version
Method one: status;
Method Two: Select version ();

2. mysql start, stop, restart common commands
A, starting mode
1. Start with service:
[[Email protected]/]# Service mysqld Start (5.0 version is mysqld)
[[Email protected] etc]# service MySQL start (5.5.7 version is MySQL)

2. Start with mysqld script:
/etc/inint.d/mysqld start

3. Start with Safe_mysqld:
safe_mysqld&

B, stop
1. Start with service:
Service Mysqld Stop

2. Start with mysqld script:
/etc/inint.d/mysqld stop

3, mysqladmin shutdown

C, restart
1. Start with service:
Service mysqld Restart
Service MySQL restart (5.5.7 version command)

2. Start with mysqld script:
/etc/init.d/mysqld restart

Turn from: North Blog

Categories: MySQL, Fodora tags: mysql, fedora, sockets, connect

Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' workaround + Linux start/stop/restart MySQL database method