啟動報錯:
/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
問題分析:
百度了下,發現這是執行scripts/mysql_install_db --user=mysql沒有成功的原因,沒有一個初始化數據庫,不能啟動mysql守護進程
解決辦法:
執行如下語句,szy為實例名
./scripts/mysql_install_db --user=szy --basedir=/opt/szy/ --datadir=/opt/szy/data/
重啟啟動,OK!