[debian-mysql] configuring mariadb on debian stretch

[Juha Heinanen]

Otto Kekäläinen writes:

> If you want to have a "clean table" regarding MySQL and MariaDB, you
> need to run 'sudo apt-get purge mariadb-* mysql-*; rm -rf /etc/mysql;
> rm -rf /var/lib/mysql'
> This will delete pretty much everything, and then you can re-install
> fresh.

Thanks for your help. As I mentioned, looks like I had manually deleted
/etc/mysql files when I tried to reinstall madiadb server.  Now
everything is working fine.  I added file

/etc/mysql/mariadb.conf.d# more 60-local.cnf 
[mysqld]
max_connections        = 200

and after restart, the variable had that value:

MariaDB [(none)]> show variables like 'max_connecti%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 200   |
+-----------------+-------+

-- Juha