啟動(dòng)報(bào)錯(cuò):
/opt/szy/bin/MySQLd: Table \'mysql.plugin\' doesn\'t exist
141211 15:06:12 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.
141211 15:06:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table \'mysql.host\' doesn\'t exist
141211 15:06:14 mysqld_safe mysqld from pid file /opt/szy/data/mysqldevdb03.pid ended
問(wèn)題分析:
百度了下,發(fā)現(xiàn)這是執(zhí)行scripts/mysql_install_db --user=mysql沒(méi)有成功的原因,沒(méi)有一個(gè)初始化數(shù)據(jù)庫(kù),不能啟動(dòng)mysql守護(hù)進(jìn)程
解決辦法:
執(zhí)行如下語(yǔ)句,szy為實(shí)例名
./scripts/mysql_install_db --user=szy --basedir=/opt/szy/ --datadir=/opt/szy/data/
重啟啟動(dòng),OK!
當(dāng)前標(biāo)題:MySQL啟動(dòng)報(bào)錯(cuò)Table'mysql.plugin'doesn'texist