Mysqld_safe mysqld from pid / var / run / mysqld / mysqld.pid prevents server reboot

Question

My mySQL server on CentOS is working correctly, but today I can not restart mysqld.

1) # / etc / rc.d / init.d / mysqld start

shows [failed]

2) see the magazine

tail /var/log/mysqld.log 
.
.
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

3) manually place

 /usr/bin/mysqld_safe

151129 15:54:36 mysqld_safe Logging to '/var/log/mysqld.log'.
151129 15:54:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151129 15:54:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

4) check the configuration

less /etc/my.cnf

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

5) check the mysql directory, each owner ship is owned by mysql. However, I cannot distinguish mysql.sock (this is set in my.cnf)

cd /var/lib/mysql　
ls -la

drwxr-xr-x  5 mysql mysql     4096 11月 29 15:54 2015 .
drwxr-xr-x 21 root  root      4096  6月  2 06:09 2015 ..
-rw-rw----  1 mysql mysql       56  6月  2 05:42 2015 auto.cnf
drwx------  2 mysql mysql     4096 11月 24 11:12 2015 myapp
-rw-rw----  1 mysql mysql 50331648 11月 29 12:30 2015 ib_logfile0
-rw-rw----  1 mysql mysql 50331648 11月 29 12:30 2015 ib_logfile1
-rw-rw----  1 mysql mysql 79691776 11月 29 12:30 2015 ibdata1
drwx------  2 mysql mysql     4096  6月  2 05:42 2015 mysql
drwx------  2 mysql mysql     4096  6月  2 05:42 2015 performance_schema

6) I found that in the directory / var / lib / mysql there is no mysql.sock in the directory / var / lib / mysql, then I will try this for testing purposes.

touch /var/lib/mysql/mysql.sock

try rebooting

/etc/rc.d/init.d/mysqld start

somehow mysql.sock is deleted.

Are there any other things I can try?

Answer 1

googled .

restorecon -r/var/lib/mysql

. .

Answer 2

, Mairadb pid /var/run/mariadb.
, pid-file=/var/run/mariadb/mysqld.pid

Answer 3

In my case, the problem was that mysql was trying to create temporary files in /var/run/mysqldthat directory did not exist. I solved the problem by manually creating the directory and setting permissions for it:

mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld

Answer 4

Just reinstall mariadb. This will fix all permissions.