after mysql update, mysql will not run.. server corrupt
Posted: Tue Jan 10, 2012 5:56 pm
hi guys
I upgraded my mysql and php on centos 5.5 to the latest version
php seems to be working fine but my mysql will not start
typing:
service mysqld start
gives this error:
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Accessing my site gives this error:
The mysqli error was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).
Iv tried yum update mysql and restarting, nothing seems to be working
i also checked the following 2 directories and i cannot find a mysql.sock file in either of them
/var/lib/mysql and
/tmp/
Can anyone help me? im desperate
The error log has the following information (located in /var/log/mysql.log) - sorry its a bit long:
Also when i run mysql_upgrade i get the following error:
I upgraded my mysql and php on centos 5.5 to the latest version
php seems to be working fine but my mysql will not start
typing:
service mysqld start
gives this error:
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Accessing my site gives this error:
The mysqli error was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).
Iv tried yum update mysql and restarting, nothing seems to be working
i also checked the following 2 directories and i cannot find a mysql.sock file in either of them
/var/lib/mysql and
/tmp/
Can anyone help me? im desperate
The error log has the following information (located in /var/log/mysql.log) - sorry its a bit long:
Code: Select all
120108 06:19:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:19:17 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:19:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:19:17 InnoDB: The InnoDB memory heap is disabled
120108 6:19:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:19:17 InnoDB: Compressed tables use zlib 1.2.3
120108 6:19:17 InnoDB: Using Linux native AIO
120108 6:19:17 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:19:17 InnoDB: Completed initialization of buffer pool
120108 6:19:17 InnoDB: highest supported file format is Barracuda.
120108 6:19:17 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:19:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:19:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:22:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:22:29 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:22:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:22:29 InnoDB: The InnoDB memory heap is disabled
120108 6:22:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:22:29 InnoDB: Compressed tables use zlib 1.2.3
120108 6:22:29 InnoDB: Using Linux native AIO
120108 6:22:29 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:22:29 InnoDB: Completed initialization of buffer pool
120108 6:22:29 InnoDB: highest supported file format is Barracuda.
120108 6:22:29 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:22:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:22:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:22:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:22:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:22:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:22:39 InnoDB: The InnoDB memory heap is disabled
120108 6:22:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:22:39 InnoDB: Compressed tables use zlib 1.2.3
120108 6:22:39 InnoDB: Using Linux native AIO
120108 6:22:39 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:22:39 InnoDB: Completed initialization of buffer pool
120108 6:22:39 InnoDB: highest supported file format is Barracuda.
120108 6:22:39 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:22:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:22:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:27:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:27:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:27:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:27:07 InnoDB: The InnoDB memory heap is disabled
120108 6:27:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:27:07 InnoDB: Compressed tables use zlib 1.2.3
120108 6:27:07 InnoDB: Using Linux native AIO
120108 6:27:07 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:27:07 InnoDB: Completed initialization of buffer pool
120108 6:27:07 InnoDB: highest supported file format is Barracuda.
120108 6:27:07 InnoDB: Waiting for the background threads to start
120108 6:27:08 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:27:08 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:27:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:29:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:29:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:29:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:29:39 InnoDB: The InnoDB memory heap is disabled
120108 6:29:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:29:39 InnoDB: Compressed tables use zlib 1.2.3
120108 6:29:39 InnoDB: Using Linux native AIO
120108 6:29:39 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:29:39 InnoDB: Completed initialization of buffer pool
120108 6:29:39 InnoDB: highest supported file format is Barracuda.
120108 6:29:40 InnoDB: Waiting for the background threads to start
120108 6:29:41 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:29:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:29:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:30:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:30:12 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:30:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:30:12 InnoDB: The InnoDB memory heap is disabled
120108 6:30:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:30:12 InnoDB: Compressed tables use zlib 1.2.3
120108 6:30:12 InnoDB: Using Linux native AIO
120108 6:30:12 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:30:12 InnoDB: Completed initialization of buffer pool
120108 6:30:12 InnoDB: highest supported file format is Barracuda.
120108 6:30:12 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:30:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:30:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:31:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:31:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:31:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:31:45 InnoDB: The InnoDB memory heap is disabled
120108 6:31:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:31:45 InnoDB: Compressed tables use zlib 1.2.3
120108 6:31:45 InnoDB: Using Linux native AIO
120108 6:31:45 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:31:45 InnoDB: Completed initialization of buffer pool
120108 6:31:45 InnoDB: highest supported file format is Barracuda.
120108 6:31:45 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:31:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:31:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:36:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:36:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:36:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:36:39 InnoDB: The InnoDB memory heap is disabled
120108 6:36:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:36:39 InnoDB: Compressed tables use zlib 1.2.3
120108 6:36:39 InnoDB: Using Linux native AIO
120108 6:36:39 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:36:39 InnoDB: Completed initialization of buffer pool
120108 6:36:39 InnoDB: highest supported file format is Barracuda.
120108 6:36:39 InnoDB: Waiting for the background threads to start
120108 6:36:40 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:36:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:36:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:40:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:40:04 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:40:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:40:04 InnoDB: The InnoDB memory heap is disabled
120108 6:40:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:40:04 InnoDB: Compressed tables use zlib 1.2.3
120108 6:40:04 InnoDB: Using Linux native AIO
120108 6:40:04 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:40:04 InnoDB: Completed initialization of buffer pool
120108 6:40:04 InnoDB: highest supported file format is Barracuda.
120108 6:40:04 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:40:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:40:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:43:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:43:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:43:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:43:48 InnoDB: The InnoDB memory heap is disabled
120108 6:43:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:43:48 InnoDB: Compressed tables use zlib 1.2.3
120108 6:43:48 InnoDB: Using Linux native AIO
120108 6:43:48 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:43:48 InnoDB: Completed initialization of buffer pool
120108 6:43:48 InnoDB: highest supported file format is Barracuda.
120108 6:43:48 InnoDB: Waiting for the background threads to start
120108 6:43:49 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:43:49 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:43:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:45:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:45:54 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:45:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:45:54 InnoDB: The InnoDB memory heap is disabled
120108 6:45:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:45:54 InnoDB: Compressed tables use zlib 1.2.3
120108 6:45:54 InnoDB: Using Linux native AIO
120108 6:45:54 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:45:54 InnoDB: Completed initialization of buffer pool
120108 6:45:54 InnoDB: highest supported file format is Barracuda.
120108 6:45:54 InnoDB: Waiting for the background threads to start
120108 6:45:55 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:45:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:45:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:52:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:52:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:52:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:52:45 InnoDB: The InnoDB memory heap is disabled
120108 6:52:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:52:45 InnoDB: Compressed tables use zlib 1.2.3
120108 6:52:45 InnoDB: Using Linux native AIO
120108 6:52:45 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:52:45 InnoDB: Completed initialization of buffer pool
120108 6:52:45 InnoDB: highest supported file format is Barracuda.
120108 6:52:45 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:52:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:52:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120109 04:46:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120109 4:46:10 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120109 4:46:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120109 4:46:10 InnoDB: The InnoDB memory heap is disabled
120109 4:46:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120109 4:46:10 InnoDB: Compressed tables use zlib 1.2.3
120109 4:46:10 InnoDB: Using Linux native AIO
120109 4:46:10 InnoDB: Initializing buffer pool, size = 128.0M
120109 4:46:10 InnoDB: Completed initialization of buffer pool
120109 4:46:10 InnoDB: highest supported file format is Barracuda.
120109 4:46:11 InnoDB: Waiting for the background threads to start
120109 4:46:12 InnoDB: 1.1.8 started; log sequence number 1595675
120109 4:46:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120109 04:46:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Code: Select all
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed