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.

David Yin

David is a blogger, geek, and web developer — founder of FreeInOutBoard.com. If you like his post, you can say thank you here

One Reply to “How to manage MariaDB in Webmin”

Leave a Reply

Your email address will not be published. Required fields are marked *