Getting errors when trying to start MySQL after installing
Posted by: Jon Christenson
Date: December 02, 2014 04:19PM

Getting errors when trying to start MySQL after installing:

141201 16:34:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141201 16:34:34 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
141201 16:34:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
141201 16:34:34 InnoDB: The InnoDB memory heap is disabled
141201 16:34:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141201 16:34:34 InnoDB: Compressed tables use zlib 1.2.3
141201 16:34:34 InnoDB: Using Linux native AIO
141201 16:34:34 InnoDB: Initializing buffer pool, size = 128.0M
141201 16:34:34 InnoDB: Completed initialization of buffer pool
141201 16:34:34 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 48941
141201 16:34:34 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 1595675
141201 16:34:34 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
141201 16:34:34 InnoDB: Waiting for the background threads to start
141201 16:34:35 InnoDB: 5.5.37 started; log sequence number 1595675
141201 16:34:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141201 16:34:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141201 16:34:35 [Note] Server socket created on IP: '0.0.0.0'.
141201 16:34:35 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
141201 16:34:35 mysqld_safe mysqld from pid file /var/lib/mysql/vlslcdba02.pid ended


I tried this: "chown -R mysql /var/lib/mysql"

Options: ReplyQuote


Subject
Written By
Posted
Getting errors when trying to start MySQL after installing
December 02, 2014 04:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.