Hi @d2d4j,
Thanks for the help. I try to open the 2 locations you said but they don’t exist as you can see bellow:
[root@server ~]# cd /var/mysql/
-bash: cd: /var/mysql/: No such file or directory
[root@server ~]# cd /var/mariadb/
-bash: cd: /var/mariadb/: No such file or directory
>> Then i try to make this:
[root@server ~]# which mysqld
/usr/sbin/mysqld
[root@server ~]# /usr/sbin/mysqld --verbose --help | grep -A 1 “Default options”
2016-09-07 2:40:29 140337878456448 [Note] Plugin ‘FEEDBACK’ is disabled.
Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf
>> So then i try to open the /etc/my.cnf file, but the content of this file is just:
[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
> So then i have made a search on all server for “*.cnf” files and the result was:
[root@server ~]# find / -type f -name “*.cnf”
/etc/pki/tls/openssl.cnf
/etc/courier/imapd.cnf
/etc/courier/pop3d.cnf
/etc/my.cnf
/etc/my.cnf.d/tokudb.cnf
/etc/my.cnf.d/client.cnf
/etc/my.cnf.d/server.cnf
/etc/my.cnf.d/mysql-clients.cnf
/usr/local/interworx/lib/letsencrypt/examples/openssl.cnf
/usr/local/interworx/mysql/usr/share/percona-server/my-small.cnf
/usr/local/interworx/mysql/usr/share/percona-server/my-large.cnf
/usr/local/interworx/mysql/usr/share/percona-server/my-huge.cnf
/usr/local/interworx/mysql/usr/share/percona-server/my-innodb-heavy-4G.cnf
/usr/local/interworx/mysql/usr/share/percona-server/my-medium.cnf
/usr/local/interworx/mysql/my.cnf
/usr/share/doc/iworx-db-55-5.5.45/my-small.cnf
/usr/share/doc/iworx-db-55-5.5.45/my-large.cnf
/usr/share/doc/iworx-db-55-5.5.45/my-huge.cnf
/usr/share/doc/iworx-db-55-5.5.45/my-innodb-heavy-4G.cnf
/usr/share/doc/iworx-db-55-5.5.45/my-medium.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/wsrep.cnf
I think the MariaDB config file is: /usr/local/interworx/mysql/my.cnf, correct?
If not, what is the correct file?
Thanks