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:
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.
At this step, you can add database or do other tasks in Webmin.
