MySQL study--mysql startup failed "Mysql.host"

MySQL Study--mysql startup Failed "Mysql.host"

System Environment :

Operating system: RedHat EL55

DB Soft:mysql 5.6.4-M7

after installing MySQL through the source package, an error occurred while booting mysqld: [email protected] mysql]# Bin/mysqld_safe &
[1] 15846
[Email protected] mysql]# 150610 17:04:36 mysqld_safe Logging to '/usr/local/mysql/data/mysql/rh55.err '.
150610 17:04:36 Mysqld_safe starting mysqld daemon with databases From/usr/local/mysql/data/mysql
150610 17:04:37 mysqld_safe mysqld from PID File/usr/local/mysql/data/mysql/rh55.pid ended

[1]+ Done Bin/mysqld_safe
To view the MySQL log:
[email protected] mysql]# More/usr/local/mysql/data/mysql/rh55.err

150610 16:56:59 Mysqld_safe starting mysqld daemon with databases from/usr/local/mysql/data/mysql/usr/local/mysql/bin/ Mysqld:table ' mysql.plugin ' doesn ' t exist150610 16:57:00 [ERROR] Can ' t open the Mysql.plugin Table. Please run Mysql_upgrade to create it.150610 16:57:00 innodb:the InnoDB memory heap is disabled150610 16:57:00 innodb:mu TExES and Rw_locks use InnoDB ' s own implementation150610 16:57:00 innodb:compressed tables use zlib 1.2.3150610 16:57:00 INNODB:CPU does not crc32 instructions150610 16:57:00 innodb:initializing buffer pool, size = 128.0m150610 16:57  : XX innodb:completed initialization of buffer poolinnodb:the first specified data file./ibdata1 did not exist:innodb:a  New database to is created!150610 16:57:00 innodb:setting file./ibdata1 size to ten mbinnodb:database physically writes The file full:wait ...  150610 16:57:01 innodb:log file./ib_logfile0 did not exist:new-be createdinnodb:setting Log file./ib_logfile0 size to 5 Mbinnodb:databasePhysically writes the file full:wait ...  150610 16:57:02 innodb:log file./ib_logfile1 did not exist:new-be createdinnodb:setting Log file./ib_logfile1 size To 5 Mbinnodb:database physically writes the file full:wait ... Innodb:doublewrite Buffer not found:creating newinnodb:doublewrite buffer created150610 16:57:04 innodb:128 rollback s Egment (s) is active. Innodb:creating FOREIGN KEY constraint system tablesinnodb:foreign key constraint system tables created150610 16:57:04 I Nnodb:waiting for the background threads to start150610 16:57:05 innodb:1.2.4 started; Log sequence number 0150610 16:57:05 [Warning] No existing UUID have been found, so we assume that this is the first time t Hat This server has been started. Generating a new uuid:ab19e2d2-0f4e-11e5-b157-080027973e8a.150610 16:57:05 [ERROR] Fatal Error:can ' t open and lock Privi Lege tables:table ' mysql.host ' doesn ' t exist150610 16:57:05 mysqld_safe mysqld from PID file/usr/local/mysql/data/mysql/ Rh55.pid ended150610 17:04:36 Mysqld_safe starting mysqld daemon with databases from/usr/local/mysql/data/mysql/usr/local/mysql/bin/ Mysqld:table ' mysql.plugin ' doesn ' t exist150610 17:04:36 [ERROR] Can ' t open the Mysql.plugin Table. Please run Mysql_upgrade to create it.150610 17:04:36 innodb:the InnoDB memory heap is disabled150610 17:04:36 innodb:mu TExES and Rw_locks use InnoDB ' s own implementation150610 17:04:36 innodb:compressed tables use zlib 1.2.3150610 17:04:36 INNODB:CPU does not crc32 instructions150610 17:04:36 innodb:initializing buffer pool, size = 128.0m150610 17:04 : innodb:completed initialization of buffer pool150610 17:04:36 innodb:highest supported file format is Barracuda.inno Db:log scan progressed past the checkpoint LSN 48961150610 17:04:36 Innodb:database was wasn't shut down normally! Innodb:starting crash recovery. innodb:reading tablespace information from the. ibd files ... innodb:restoring possible Half-written data pages from the Doublewriteinnodb:buffer ... InchNodb:doing recovery:scanned up to log sequence number 1595695150610 17:04:36 innodb:starting an apply batch of log rec Ords to the database ...  Innodb:progress in percents: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 The above-the-yi-yi-yi-yi-yi-yi-yi-yi-yi-yi-yi-yi-94-98-innodb:apply batch completed150610 17:04:37 Inno db:128 rollback segment (s) is active.150610 17:04:37 innodb:1.2.4 started; Log sequence number 1595695150610 17:04:37 [note] Recovering after a crash using mysql-bin150610 17:04:37 [note] Starting Crash recovery ... 150610 17:04:37 [Note] Crash recovery finished.150610 17:04:37 [ERROR] Fatal Error:can ' t open and lock privilege tables: Table ' mysql.host ' doesn ' t exist150610 17:04:37 mysqld_safe mysqld from PID File/usr/local/mysql/data/mysql/rh55.pid end Ed

To view the MySQL configuration file:
[email protected] ~]# cat/etc/my.cnf

[Mysqld]port            = 3306socket =          /tmp/mysql.sockskip-external-lockingkey_buffer_size = 16mmax_allowed_packet = 1mtable_open_cache = 64sort_buffer_size = 512knet_buffer_length = 8kread_buffer_size = 256Kread_rnd_buffer_size = 512kmyisam_sort_buffer_size = 8mdatadir=/usr/local/mysql/data/mysql

Solution:
[email protected] mysql]# scripts/mysql_install_db--user=mysql--datadir=/usr/local/mysql/data/mysql

Warning:the host ' rh55 ' could not being looked up with RESOLVEIP. This probably means that your libc libraries is not the Compatiblewith this binary MySQL version. The MySQL daemon, mysqld, should worknormally with the exception that host name resolving won't work. This means the should use IP addresses instead of Hostnameswhen specifying MySQL privileges! Installing MySQL system tables ... 150610 17:07:10 innodb:the InnoDB memory heap is disabled150610 17:07:10 innodb:mutexes and rw_locks use InnoDB ' s own im plementation150610 17:07:10 innodb:compressed Tables use zlib 1.2.3150610 17:07:10 INNODB:CPU does no support CRC32 ins tructions150610 17:07:10 innodb:initializing buffer pool, size = 128.0m150610 17:07:10 innodb:completed initialization o F buffer pool150610 17:07:10 innodb:highest supported file format is BARRACUDA.INNODB:LOG scan progressed past the check Point LSN 48961150610 17:07:10 innodb:database is 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 Doublewriteinnodb:buffer ... Innodb:doing recovery:scanned up to log sequence number 1595695150610 17:07:11 innodb:starting an apply batch of log R Ecords to the database ...  Innodb:progress in percents: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 The above-the-yi-yi-yi-yi-yi-yi-yi-yi-yi-yi-yi-yi-94-98-innodb:apply batch completed150610 17:07:11 Inno db:128 rollback segment (s) is active.150610 17:07:11 innodb:waiting for the background threads to start150610 17:07:12 innodb:1.2.4 started; Log sequence number 1595695150610 17:07:12 [note] Recovering after a crash using mysql-bin150610 17:07:12 [note] Starting Crash recovery ... 150610 17:07:12 [Note] Crash recovery finished.150610 17:07:14 [Warning] Info table is isn't ready to be used. Table ' Mysql.slave_master_info ' cannot be opened.150610 17:07:14 [warninG] Error while checking replication metadata. Setting the requested repository in order to give users, the chance to fix the problem and restart the server. If This is a live upgrade you consider using Mysql_upgrade to fix the problem.150610 17:07:14 [Warning] Info table is n OT ready-to-be used. Table ' Mysql.slave_relay_log_info ' cannot is opened.150610 17:07:14 [Warning] Error while checking replication metadata. Setting the requested repository in order to give users, the chance to fix the problem and restart the server. If This is a live upgrade you consider using Mysql_upgrade to fix the problem.150610 17:07:15 [Note] Binlog end150610 1 7:07:15 [note] shutting plugin ' partition ' 150610 17:07:15 [note] shutting down plugin ' Innodb_sys_foreign_cols ' 15061 0 17:07:15 [note] shutting down plugin ' innodb_sys_foreign ' 150610 17:07:15 [Note] shutting down plugin ' Innodb_sys_fields ' 150610 17:07:15 [note] shutting down plugin ' innodb_sys_columns ' 150610 17:07:15 [note] shutting down plugIn ' innodb_sys_indexes ' 150610 17:07:15 [note] shutting down plugin ' innodb_sys_tablestats ' 150610 17:07:15 [note] Shutting down plugin ' innodb_sys_tables ' 150610 17:07:15 [Note] shutting down plugin ' innodb_ft_index_table ' 150610 17:07:15 [note] shutting plugin ' innodb_ft_index_cache ' 150610 17:07:15 [note] shutting down plugin ' Innodb_ft_config ' 150610 17:07:15 [note] shutting down plugin ' innodb_ft_being_deleted ' 150610 17:07:15 [note] shutting down plugin ' innodb_ ft_deleted ' 150610 17:07:15 [note] shutting down plugin ' innodb_ft_inserted ' 150610 17:07:15 [note] shutting down plugin ' in Nodb_ft_default_stopword ' 150610 17:07:15 [note] shutting down plugin ' innodb_metrics ' 150610 17:07:15 [note] Shutting Down plugin ' innodb_buffer_pool_stats ' 150610 17:07:15 [Note] shutting down plugin ' INNODB_BUFFER_PAGE_LRU ' 150610 17:07:15 [note] shutting plugin ' innodb_buffer_page ' 150610 17:07:15 [note] shutting down plugin ' Innodb_cmpmem_reset ' 150610 17:07:15 [Note] shutting down plugin ' INNODB_CMPMEM ' 150610 17:07:15 [note] shutting down plugin ' innodb_cmp_reset ' 150610 17:07:15 [note] shutting down plugin ' innodb_cmp ' 1 50610 17:07:15 [note] shutting down plugin ' innodb_lock_waits ' 150610 17:07:15 [Note] shutting down plugin ' innodb_locks ' 15  0610 17:07:15 [note] shutting down plugin ' Innodb_trx ' 150610 17:07:15 [Note] shutting down plugin ' INNODB ' 150610 17:07:15 Innodb:fts optimize thread exiting.150610 17:07:15 innodb:starting shutdown ... 150610 17:07:16 Innodb:shutdown completed;  Log sequence number 1602851150610 17:07:16 [note] shutting down plugin ' Performance_schema ' 150610 17:07:16 [note] Shutting Down plugin ' CSV ' 150610 17:07:16 [note] shutting down plugin ' Mrg_myisam ' 150610 17:07:16 [note] shutting down plugin ' MEM ORY ' 150610 17:07:16 [note] shutting down plugin ' MyISAM ' 150610 17:07:16 [Note] shutting down plugin ' Mysql_old_password ' 15 0610 17:07:16 [note] shutting down plugin ' Mysql_native_password ' 150610 17:07:16 [Note] shutting down plugin ' Binlog ' Okfil Ling Help Tables ... 150610 17:07:16 innodb:the InnoDB memory heap is disabled150610 17:07:16 innodb:mutexes and rw_locks use InnoDB ' s own imp lementation150610 17:07:16 innodb:compressed Tables use zlib 1.2.3150610 17:07:16 INNODB:CPU does no support CRC32 Inst  ructions150610 17:07:16 innodb:initializing buffer pool, size = 128.0m150610 17:07:16 innodb:completed initialization of Buffer pool150610 17:07:16 innodb:highest supported file format is barracuda.150610 17:07:17 innodb:128 rollback segmen T (s) is active.150610 17:07:17 innodb:1.2.4 started; Log sequence number 1602851150610 17:07:17 [note] Binlog end150610 17:07:17 [note] shutting down plugin ' partition ' 150610 17:07:17 [note] shutting plugin ' innodb_sys_foreign_cols ' 150610 17:07:17 [note] shutting down plugin ' innodb_sys_for Eign ' 150610 17:07:17 [note] shutting down plugin ' innodb_sys_fields ' 150610 17:07:17 [note] shutting down plugin ' Innodb_sy S_columns ' 150610 17:07:17 [Note] shutting down plugin ' innodb_sys_indexes ' 150610 17:07:17 [NOTE] Shutting plugin ' innodb_sys_tablestats ' 150610 17:07:17 [Note] shutting down plugin ' innodb_sys_tables ' 150610 17 : 07:17 [note] shutting plugin ' innodb_ft_index_table ' 150610 17:07:17 [note] shutting down plugin ' Innodb_ft_index_ca CHE ' 150610 17:07:17 [note] shutting down plugin ' innodb_ft_config ' 150610 17:07:17 [note] shutting down plugin ' Innodb_ft_b eing_deleted ' 150610 17:07:17 [note] shutting down plugin ' innodb_ft_deleted ' 150610 17:07:17 [note] shutting down plugin ' I nnodb_ft_inserted ' 150610 17:07:17 [note] shutting down plugin ' Innodb_ft_default_stopword ' 150610 17:07:17 [note] Shutting down plugin ' innodb_metrics ' 150610 17:07:17 [Note] shutting down plugin ' innodb_buffer_pool_stats ' 150610 17:07:17 [note] shutting plugin ' INNODB_BUFFER_PAGE_LRU ' 150610 17:07:17 [note] shutting down plugin ' innodb_buffer_p Age ' 150610 17:07:17 [note] shutting down plugin ' innodb_cmpmem_reset ' 150610 17:07:17 [note] shutting down plugin ' Innodb_c Mpmem ' 150610 17:07:17 [Note] shutting down pLugin ' Innodb_cmp_reset ' 150610 17:07:17 [note] shutting down plugin ' innodb_cmp ' 150610 17:07:17 [note] shutting down Plugi  N ' innodb_lock_waits ' 150610 17:07:17 [note] shutting down plugin ' innodb_locks ' 150610 17:07:17 [note] shutting down plugin ' Innodb_trx ' 150610 17:07:17 [Note] shutting down plugin ' INNODB ' 150610 17:07:17 innodb:fts optimize thread exiting.1506 Ten 17:07:17 innodb:starting shutdown ... 150610 17:07:18 Innodb:shutdown completed;  Log sequence number 1602861150610 17:07:18 [note] shutting down plugin ' Performance_schema ' 150610 17:07:18 [note] Shutting Down plugin ' CSV ' 150610 17:07:18 [note] shutting down plugin ' Mrg_myisam ' 150610 17:07:18 [note] shutting down plugin ' MEM ORY ' 150610 17:07:18 [note] shutting down plugin ' MyISAM ' 150610 17:07:18 [Note] shutting down plugin ' Mysql_old_password ' 15 0610 17:07:18 [note] shutting down plugin ' Mysql_native_password ' 150610 17:07:18 [Note] shutting down plugin ' Binlog ' OKto Start mysqld at boot time with to Copysupport-files/mysql. server to the your systemplease REMEMBER to SET A PASSWORD for the MySQL root USER! To does, start the server, then issue the following commands:./bin/mysqladmin-u root password ' new-password './bin/mysqla Dmin-u root-h rh55 password ' new-password ' Alternatively you can Run:./bin/mysql_secure_installationwhich would also give  The option of removing the testdatabases and anonymous user created by default. This isstrongly recommended for production servers. See the Manual for more instructions. You can start the MySQL daemon with:cd. ;./bin/mysqld_safe &you can test the MySQL daemon with MYSQL-TEST-RUN.PLCD./mysql-test; Perl mysql-test-run.plplease Report no problems with the./bin/mysqlbug script!

start MySQL server:

[email protected] mysql]# Bin/mysqld_safe &
[1] 16199
[email protected] mysql]# 150610 17:08:22 mysqld_safe Logging to '/usr/local/mysql/data/mysql/rh55.err '.
150610 17:08:22 Mysqld_safe starting mysqld daemon with databases From/usr/local/mysql/data/mysql

Verify startup success:
[email protected] mysql]# Netstat-an |grep 3306
TCP 0 0::: 3306:::* LISTEN

MySQL study--mysql startup failed "Mysql.host"