[debian-mysql] configuring mariadb on debian stretch

[Juha Heinanen]

Otto Kekäläinen writes:

> Cam you provide some more info about your setup so we can help debug
> why the config does not work? What mariadb-packages (revision number)
> do you have installed)
> What does 'ls -la /etc/mysql/**' show?

Otto,

Thanks for your reply.  This is up to date Debian Stretch with these
mariadb packages:

 dpkg -l | egrep mariadb
ii  libmariadbclient-dev                  10.1.22-3                         amd64        MariaDB database development files
ii  libmariadbclient-dev-compat:amd64     10.1.22-3                         amd64        MariaDB database development files (libmysqlclient compatibility)
ii  libmariadbclient18:amd64              10.1.22-3                         amd64        MariaDB database client library
ii  mariadb-client-10.1                   10.1.22-3                         amd64        MariaDB database client binaries
ii  mariadb-client-core-10.1              10.1.22-3                         amd64        MariaDB database core client binaries
ii  mariadb-common                        10.1.22-3                         all          MariaDB common metapackage
ii  mariadb-server-10.1                   10.1.22-3                         amd64        MariaDB database server binaries
ii  mariadb-server-core-10.1              10.1.22-3                         amd64        MariaDB database core server files

After installation, these files appeared in /etc/mysql:

root at rautu:/etc/mysql# ls -lsR .
.:
total 12
4 -rw------- 1 root root  277 Apr 14 19:32 debian.cnf
4 -rwxr-xr-x 1 root root 1509 Mar 28 23:59 debian-start
4 drwxr-xr-x 2 root root 4096 Apr 16 09:14 mariadb.conf.d

./mariadb.conf.d:
total 8
4 -rw-r--r-- 1 root root 1032 Mar 28 23:59 50-mysqld_safe.cnf
4 -rw-r--r-- 1 root root 3718 Apr 16 09:06 50-server.cnf

File /etc/mysql/mariadb.conf.d/50-server.cnf had line

#max_connections        = 100

I un-commented it and edited like this:

max_connections        = 200

restarted mysql and noticed that the line had no effect.

Then I tried by creating file /etc/mysql/mariadb.conf.d/10-local.cnf
with lines:

[mysqld]
max_connections        = 200

restarted mysql and noticed that the file had no effect.

-- Juha