Start, Stop, Restart MariaDB-Server on remote server

MH's profile image MH posted 3 years ago in General Permalink

I'm new to database administration. I have already looked, but did not immediately find what I was looking for. I have a MariaDB database running on a Linux server. I want a colleague to have access to the database, but not to the Linux system. How can the colleague start, stop or restart the database from a remote Windows computer via HeidiSql? With MySql-Workbench i can do this.

Thanks for your help.

ansgar's profile image ansgar posted 3 years ago Permalink

MySQL has a RESTART SQL command for that purpose: https://dev.mysql.com/doc/refman/8.0/en/restart.html

MariaDB seems to only support SHUTDOWN: https://mariadb.com/kb/en/shutdown/

Please login to leave a reply, or register at first.