大佬們求解答,怎么解決這個問題, mysql重啟服務失敗
190807 00:27:54 mysqld_safe Starting mysqld daemon with databases from //www/server/mysql
/www/server/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
190807 0:27:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
190807 0:27:54 InnoDB: Initializing buffer pool, size = 8.0M
190807 0:27:54 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
190807 0:27:54 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
190807 0:27:54 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
190807 0:27:54 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
190807 0:27:54 InnoDB: Started; log sequence number 0 0
190807 0:27:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
190807 00:27:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
uj5u.com熱心網友回復:
這個啟動報錯是因為你的默認組態檔/etc/my.cnf中的datadir的路徑為默認路徑,而不是你自己設定的路徑導致的,修改一下應該就可以了。uj5u.com熱心網友回復:
你都打開日志了,就搜一下唄https://www.cnblogs.com/already/p/5944803.html
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/51328.html
標籤:MySQL
下一篇:hive鎖表機制產生的問題
