VI/ETC/MY.CNF View Log file path:
Log-error=/var/log/mysqld.log
To view the error log:
Before the server was taken by others, so they bought a U.S. VPS, according to the notes installed after the start of MySQL, and can not start.
View the error log
Reference 090321 18:55:03 Mysqld_safe starting mysqld daemon with databases From/usr/local/mysql/data
/usr/local/mysql/libexec/mysqld:table ' mysql.plugin ' doesn ' t exist
090321 18:55:03 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.
090321 18:55:03 innodb:started; Log sequence number 0 46409
090321 18:55:03 [Note] Recovering after a crash using Mysql-bin
090321 18:55:03 [Note] starting crash recovery ...
090321 18:55:03 [Note] Crash recovery finished.
090321 18:55:03 [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist
090321 18:55:03 mysqld_safe mysqld from PID File/usr/local/mysql/data/srv.willko.cn.pid ended
This is primarily due to installation-time permissions issues that caused the installation to fail: I sweat, how to install the time without prompting it.
Modify the permissions of the data directory under MySQL chown-r mysql:mysql/data/mysql (datadir=/data/mysql), and then execute mysql_install_db.
Executive Authorization:
Linux MySQL startup error can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist