二进制安装后,启动时出现问题(mysql安装在/application/msyql下):
[root@135 bin]# /etc/init.d/mysqld start
Starting MySQL.170320 22:21:51 mysqld_safe The file /usr/local/mysql/bin/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information
ERROR! The server quit without updating PID file (/application/mysql/data/135.pid).
解决办法和思路:
首先是按照错误的提示操作,严格的执行./bin/mysqld_safe&,之后可以启动,启动的进行如下:
mysql 4389 4243 2 22:23 pts/0 00:00:00 ./bin/mysqld --basedir=/application/mysql --datadir=/application/mysql/data --plugin-dir=/application/mysql/lib/plugin --user=mysql --log-error=/application/mysql/data/135.err --pid-file=/application/mysql/data/135.pid
可以看出用/etc/init.d/mysqld启动,之所以出现如上的错误,还是配置文件的问题,没有找到配置的文件。可执行命令 ./bin/mysqld_safe --defaults-file=/etc/my.cnf 指定已经配好的配置文件。