Hello,
I'm using "mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1" on CentOS 8.
How can I set "max_password_errors" and "bind-address=127.0.0.1"?
Which file must be edit? The "/etc/my.cnf" or "/etc/my.cnf.d/mariadb-server.cnf"?
Thank you.
MariaDB.
Re: MariaDB.
Interesting way to express that.
I would tell the output of rpm -q mariadb-server or dnf list mariadb-server.
The current default mariadb in CentOS 8 is
Code: Select all
mariadb-server.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6 @AppStream
Does the /etc/my.cnf contain something like:
Code: Select all
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
See https://mariadb.com/kb/en/configuring-m ... irectories
and https://mariadb.com/kb/en/configuring-m ... ile-syntax
Therefore, I would say: neither. Add a file of your own into /etc/my.cnf.d/
That way settings by you stay neatly separate from whatever the package provides.
Re: MariaDB.
Thank you.
On my server:
And:
Thus, I should create a file under "/etc/my.cnf.d/" directory and put below lines into it:
Am I right?
On my server:
Code: Select all
# rpm -q mariadb-server
mariadb-server-10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
Code: Select all
$ cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#bind-address =127.0.0.1
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
Code: Select all
max_password_errors=10
bind-address=127.0.0.1