我按照一篇文章一步一步的做的,前面都没问题作到这里:启动测试
./mysql.server start
失败提示:
[root@linuxprobe support-files]# ./mysql.server start
Starting MySQL.2017-10-26T08:20:34.772472Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
ERROR! The server quit without updating PID file (/var/lib/mysql/linuxprobe.com.pid).
是怎么回事呀????
./mysql.server start
失败提示:
[root@linuxprobe support-files]# ./mysql.server start
Starting MySQL.2017-10-26T08:20:34.772472Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
ERROR! The server quit without updating PID file (/var/lib/mysql/linuxprobe.com.pid).
是怎么回事呀????
这里报的是log文件不存在,mysql用户又没有权限创建。
创建/var/log/mariadb/mariadb.log文件,授权给mysql用户。
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
楼上的高手你帮我看看我这里是不是有/var/log/mariadb/mariadb.log文件了呀,可以进一步帮我分析问题出在哪里么?
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/
mkdir -p /var/run/mariadb/
chown -R mysql:mysql /var/run/mariadb/
重启数据库即可。
# rpm -qa|grep -i mariadb-libs
# rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps