131203 23:09:36 Mysqld_safe starting mysqld daemon with databases From/mnt/mysqldata
2013-12-03 23:09:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use--explicit_defaults_for_timestamp server option (the documentation for more details).
2013-12-03 23:09:36 2563 [note] Plugin ' federated ' is disabled.
/usr/local/mysql/bin/mysqld:table ' mysql.plugin ' doesn ' t exist
2013-12-03 23:09:36 2563 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.
2013-12-03 23:09:36 2563 [note] innodb:the InnoDB memory heap is disabled
2013-12-03 23:09:36 2563 [note] innodb:mutexes and rw_locks use GCC atomic builtins
2013-12-03 23:09:36 2563 [note] innodb:compressed tables use zlib 1.2.3
2013-12-03 23:09:36 2563 [note] innodb:using CPU CRC32 Instructions
2013-12-03 23:09:36 2563 [note] innodb:initializing buffer pool, size = 128.0M
2013-12-03 23:09:36 2563 [note] innodb:completed initialization of buffer pool
2013-12-03 23:09:36 2563 [note] innodb:highest supported the file format is barracuda.
2013-12-03 23:09:36 2563 [note] Innodb:log scan progressed past the checkpoint LSN 49463
2013-12-03 23:09:36 2563 [note] innodb:database is not shutdown normally!
2013-12-03 23:09:36 2563 [note] innodb:starting crash recovery.
2013-12-03 23:09:36 2563 [note] innodb:reading tablespace information from the ... ibd files ...
2013-12-03 23:09:36 2563 [note] innodb:restoring possible half-written data pages
2013-12-03 23:09:36 2563 [note] innodb:from the doublewrite buffer ...
Innodb:doing recovery:scanned up to log sequence number 1600607
2013-12-03 23:09:36 2563 [note] innodb:starting a apply batch of log records to the database ...
Innodb:progress in Percent: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
innodb:apply Batch Completed
2013-12-03 23:09:36 2563 [note] innodb:128 rollback segment (s) are active.
2013-12-03 23:09:36 2563 [note] innodb:waiting for purge to start
2013-12-03 23:09:36 2563 [note] innodb:5.6.14 started; Log sequence Number 1600607
2013-12-03 23:09:36 2563 [note] Server hostname (bind-address): ' * '; port:3306
2013-12-03 23:09:36 2563 [note] IPv6 is available.
2013-12-03 23:09:36 2563 [note]-':: ' resolves to ':: ';
2013-12-03 23:09:36 2563 [note] Server socket created on IP: ':: '.
2013-12-03 23:09:36 2563 [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.user ' doesn ' t exist
Solution:
1. Create the initial file:
./scripts/mysql_install_db--user=mysql--ldata=/mnt/mysqldata
2. Delete duplicate configuration files my.cnf
3. See Official documents
Http://dev.mysql.com/doc/refman/5.6/en/option-files.html