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