How to manage MariaDB in Webmin

It is easy to use Webmin to manage VPS, including MySQL server.  But it is not working with MariaDB default.

The webmin MySQL server shows error as below:

mariadb-webmin

It can not find the path of command to start and stop MariaDB and also config file of MariaDB server.

So click module configuration and change:
Command to start MySQL server: /etc/init.d/mysql start
Command to stop MySQL server: /etc/init.d/mysql stop
MySQL configuration file: /var/lib/mysql/my.cnf

If your MariaDB server configuration file is not in this location, double check your setting and enter the correct value.

After saving, it will ask for your username and password to connect your MariaDB server.  Enter them and save.

mariadb-settings

At this step, you can add database or do other tasks in Webmin.