+- 96MB Forum (http://96forum.com)
+-- Forum: VPS Discussions (http://96forum.com/forumdisplay.php?fid=32)
+--- Forum: VPS Discussions (http://96forum.com/forumdisplay.php?fid=42)
+--- Thread: Percona MySQL won't start (/showthread.php?tid=199)
Percona MySQL won't start - zhuanyi - 10-01-2013
I have installed a fresh copy of Percona MySQL 5.5 and for some reason it won't start, here is the verbose output:
Code:
mysqld --verbose 131001 20:59:32 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
131001 20:59:32 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
mysqld: Table 'mysql.plugin' doesn't exist
131001 20:59:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
131001 20:59:32 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
131001 20:59:32 InnoDB: The InnoDB memory heap is disabled
131001 20:59:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131001 20:59:32 InnoDB: Compressed tables use zlib 1.2.3
131001 20:59:32 InnoDB: Using Linux native AIO
131001 20:59:32 InnoDB: Initializing buffer pool, size = 128.0M
131001 20:59:32 InnoDB: Completed initialization of buffer pool
131001 20:59:32 InnoDB: highest supported file format is Barracuda.
131001 20:59:32 InnoDB: Waiting for the background threads to start
131001 20:59:33 Percona XtraDB (http://www.percona.com) 5.5.33-29.3 started; log sequence number 1597945
131001 20:59:33 [Note] Recovering after a crash using mysql-bin
131001 20:59:33 [Note] Starting crash recovery...
131001 20:59:33 [Note] Crash recovery finished.
131001 20:59:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't existHowever I have installed various DB tables using the install_table script:
Code:
Installing MySQL system tables...
131001 21:00:07 [Warning] Using unique option prefix key_buffer instead of key_b uffer_size is deprecated and will be removed in a future release. Please use the full name instead.
131001 21:00:07 [Note] WSREP: Read nil XID from storage engines, skipping positi on init
131001 21:00:07 [Note] WSREP: wsrep_load(): loading provider library 'none'
131001 21:00:07 [Note] WSREP: Service disconnected.
131001 21:00:08 [Note] WSREP: Some threads may fail to exit.
OK
Filling help tables...
131001 21:00:08 [Warning] Using unique option prefix key_buffer instead of key_b uffer_size is deprecated and will be removed in a future release. Please use the full name instead.
131001 21:00:08 [Note] WSREP: Read nil XID from storage engines, skipping positi on init
131001 21:00:08 [Note] WSREP: wsrep_load(): loading provider library 'none'
131001 21:00:08 [Note] WSREP: Service disconnected.
131001 21:00:09 [Note] WSREP: Some threads may fail to exit.
OKHelp please?[/code]