安装完成之后,启动MySQL服务
报错:
[root@localhost bin]# /usr/local/mysql/support-files/mysql.server start
Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).
在网上找了各种方法之后,发现是/etc/my.cnf配置文件的问题:
原来是
[mysqld]
dir=/usr/local/mysql/data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8
改成
[mysqld]
datadir=/usr/local/mysql/data //修改了这个地方
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8
之后,问题解决,能够成功开启mysql服务