How to start / stop / restart / enable / reload the MySQL & MariaDB server in Linux

BY MAGESH MARUTHAMUTHU · PUBLISHED : OCTOBER 9, 2013 || LAST UPDATED: JANUARY 23, 2016

Systemd is a new init system and system manager which was implemented/adapted into all the major Linux distributions over the traditional SysV init systems due to lots of issue/improvement has to be on sysVinit systems. All the services is available “/etc/init.d/. If you want to start, stop, restart, enable, reload & status of the service follow the below commands to do it. Either root or sudo Permission needed to run the below commands.

1) To Start MySQL/MariaDB server

Use the below commands to start the MySQL/MariaDB server in Linux.

# For Sysvinit Systems #
# service mysql start
or
# /etc/init.d/mysql start

# For Systemd Systems #
# systemctl start mariadb.service
or
# systemctl start mysql.service
or
# systemctl start mariadb
or
# systemctl start mysql

2) To Stop MySQL/MariaDB server

Use the below commands to stop the MySQL/MariaDB server in Linux.

# For Sysvinit Systems #
# service mysql stop
or
# /etc/init.d/mysql stop

# For Systemd Systems #
# systemctl stop mariadb.service
or
# systemctl stop mysql.service
or
# systemctl stop mariadb
or
# systemctl stop mysql

3) To Restart MySQL/MariaDB server

Use the below commands to restart the MySQL/MariaDB server in Linux.

# For Sysvinit Systems #
# service mysql restart
or
# /etc/init.d/mysql restart

# For Systemd Systems #
# systemctl restart mariadb.service
or
# systemctl restart mysql.service
or
# systemctl restart mariadb
or
# systemctl restart mysql

4) To Reload MySQL/MariaDB server

Use the below commands to reload the MySQL/MariaDB server in Linux.

# For Sysvinit Systems #
# service mysql reload
or
# /etc/init.d/mysql reload

# For Systemd Systems #
# systemctl reload mariadb.service
or
# systemctl reload mysql.service
or
# systemctl reload mariadb
or
# systemctl reload mysql

5) To view status of MySQL/MariaDB server

Use the below commands to view the status of MySQL/MariaDB server in Linux.

# For Sysvinit Systems #
# service mysql status
or
# /etc/init.d/mysql status

# For Systemd Systems #
# systemctl status mariadb.service
or
# systemctl status mysql.service
or
# systemctl status mariadb
or
# systemctl status mysql

6) To Enable MySQL/MariaDB server in boot

Use the below commands to enable the MySQL/MariaDB server in boot. In sysVinit system we can use Chkconfig command to configure services in boot via /etc/rd.d/init.d script & Systemd system via /usr/lib/systemd/system script.

# For Sysvinit Systems #
# chkconfig mysqld on

# For Systemd Systems #
# systemctl enable mariadb.service
or
# systemctl enable mysql.service
or
# systemctl enable mariadb
or
# systemctl enable mysql