CentOS install MySQL 5.6 Unable to start Table ' mysql.plugin ' doesn ' t exist

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.