MySQL database New installation does not start

Source: Internet
Author: User

MySQL database source code after compiling, start failure specific error log is as follows:

2018-04-13 23:45:46 67547 [Note] Plugin ' federated ' is disabled./usr/local/mysql/bin/mysqld:table ' mysql.plugin ' doesn ' T exist2018-04-13 23:45:46 67547 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.2018-04-13 23:45:46 67547 [Note] innodb:using Atomics to ref count buffer pool page S2018-04-13 23:45:46 67547 [note] innodb:the InnoDB memory heap is disabled2018-04-13 23:45:46 67547 [note] Innodb:mutex Es and Rw_locks use GCC atomic builtins2018-04-13 23:45:46 67547 [Note] innodb:memory barrier are not used2018-04-13 23:45 : 67547 [note] innodb:compressed tables use zlib 1.2.32018-04-13 23:45:46 67547 [note] innodb:using CPU CRC32 Instruct IONS2018-04-13 23:45:46 67547 [note] innodb:initializing buffer pool, size = 128.0m2018-04-13 23:45:46 67547 [note] InnoD B:completed initialization of buffer pool2018-04-13 23:45:46 67547 [Note] innodb:highest supported file format is Barrac UDA.2018-04-13 23:45:46 67547 [Note] innodb:log scan progressed past thE checkpoint LSN 494632018-04-13 23:45:46 67547 [Note] innodb:database was not shutdown normally!2018-04-13 23:45:46 6754 7 [note] innodb:starting crash recovery.2018-04-13 23:45:46 67547 [note] innodb:reading tablespace information from the . ibd Files ... 2018-04-13 23:45:46 67547 [note] innodb:restoring possible half-written data pages 2018-04-13 23:45:46 67547 [note] Innod B:from the Doublewrite buffer ... Innodb:doing recovery:scanned up to log sequence number 16006072018-04-13 23:45:46 67547 [Note] innodb:starting an APPL y batch of log records to the database ... Innodb:progress in percent: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 The Yi-yi-ba-yi-yi-yi-yi-yi-yi-yi-yi-94-98-innodb:apply batch COMPLETED2018-04-13 23:45:46 67547 [not E] innodb:128 rollback segment (s) is active.2018-04-13 23:45:46 67547 [Note] innodb:waiting for purge to Start2018-04-1 3 23:45:46 67547 [Note] innodb:5.6.39 started; Log SequencE number 16006072018-04-13 23:45:46 67547 [Note] Server hostname (bind-address): ' * '; PORT:33062018-04-13 23:45:46 67547 [note] IPv6 is available.2018-04-13 23:45:46 67547 [note]-':: ' resolves to ':: '; 20  18-04-13 23:45:46 67547 [Note] Server socket created on IP: ':: '. 2018-04-13 23:45:46 67547 [ERROR] Fatal error:can ' t open and lock Privilege tables:table ' mysql.user ' doesn ' t exist

Workaround:
Reinitialization of the database can
shell>/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/ Mysql/data '
After the database starts successfully
Shell>/etc/init.d/mysqld Start
Starting MySQL. success!

To set the root user login password:
shell> mysqladmin-uroot-p password ' 123456 '
Enter Password: "The default password is empty direct carriage return"
Warning:using a password on the command line interface can be insecur

MySQL database New installation does not start

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.