1、安装mysql:
这位老兄的方法非常棒:推荐:
https://blog.csdn.net/fireroll/article/details/48828945
2、安装完成之后启动,然后查看mysql是否启动,出现ERROR表示mysql没有正确启动,找到原因并解决之后重新启动mysql;
$ /etc/init.d/mysqld status
$ ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
3、启动mysql的方法:
$ /etc/init.d/mysqld start
4、如果出错,在 目录下找错误日志,一般可以找到启动出错的直接原因,然后对症下药,比如下面问题:
181020 9:54:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
181020 9:54:22 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
5、针对上述错误:一个有效的解决办法就是设置basedir参数,执行完这句话之后再启动mysql就正常了。
mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/
6、再次启动mysql:
# /etc/init.d/mysqld status
ERROR! MySQL is not running, but lock exists
# /etc/init.d/mysqld start
Starting MySQL. SUCCESS!
# /etc/init.d/mysqld status
SUCCESS! MySQL running (22816)