关于yum安装mariadb后自定义配置文件报错求助

sxfxtf

用的是yum安装mariadb,配置yum源,下载 安装 然后systemctl start mariadb 都成功.



此时my.cnf配置文件是这样的.只是设置了些字符编码

[Python] 纯文本查看 复制代码

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
log-error=/var/log/mysqld.log
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

然后想自定义mariadb的data,log路径,于是配置文件添加了几行, mkdir -p /opt/local/mysql,

[Python] 纯文本查看 复制代码

[mysqld]
basedir = /opt/local/mysql
datadir=/opt/local/mysql/data
pid-file = /opt/local/mysql/mysql.pid
log-error = /opt/local/mysql/logs/mysqld.log
character-set-server=utf8
collation-server=utf8_general_ci
log-error=/var/log/mysqld.log
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

再次运行就报错,麻烦各位看下 /opt/local/mysql  我也chmod 777权限了  为何还是报错,如果要自定义日志和数据库路径 要怎么操作呢,卡了三天了 难受啊

Saryta

https://support.cpanel.net/hc/en-us/articles/360054053813-How-to-Enable-the-Error-Log-in-MySQL-or-MariaDB
试试这个，log_error
mysqld: log-error
mariadb: log_error

sxfxtf

Saryta 发表于 2022-4-1 22:03
https://support.cpanel.net/hc/en-us/articles/360054053813-How-to-Enable-the-Error-Log-in-MySQL-or-Ma ...

还是不行,似乎不是这个问题.

Saryta

我在centos7中试了一下这样没什么问题，getenforce看一下selinux运行模式，我这里唯一的问题就是Enforing导致了无法启动，设置为Permissive就可以了，setenforce 0 或从配置文件中永久修改。

[root@localhost ~]# cat /etc/my.cnf
[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/opt/local/mysql
socket=/opt/local/mysql/mysql.sock
log-error=/opt/local/mysql/logs/mysqld.log
character-set-server=utf8
collation-server=utf8_general_ci
#log-error=/var/log/mysqld.log
# 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

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

#
# include all files from the config directory
!includedir /etc/my.cnf.d

大罗金仙

好东西，拿走了

sxfxtf

Saryta 发表于 2022-4-1 23:26
[md]我在centos7中试了一下这样没什么问题，`getenforce`看一下selinux运行模式，我这里唯一的问题就是`Enf ...

多谢,我也找到问题了,一个是主组的权限没有设置mysql,另一个就是selinux