ОС Федора 9вчера обновил систему yum upgrade, после чего MySQL перестал запускаться.
Все права перепроверял, все нормально. Когда в my.conf указываю user=root, то запускается нормально.
запускаю мускул:
[13:41][root@xxx:/var/run]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[13:42][root@xxx:/var/run]#
в логах появилось вижу вот это:
081116 13:53:03 mysqld started
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
081116 13:53:03 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
081116 13:53:03 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
081116 13:53:03 InnoDB: Started; log sequence number 0 43655
081116 13:53:03 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
081116 13:53:03 [ERROR] Can't start server: can't create PID file: Permission denied
081116 13:53:03 mysqld ended
права на папку /var/run/mysqld:
[14:00][root@xxx:/var/run]# ls -l
...
drwxrwxrwx 2 mysql mysql 4096 2008-03-04 05:39 mysqld
...
my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
SELINUX отключен.
второй день ковыряю эту проблему, не знаю куда дальше смотреть...