You could need to restart MySQL server after installing, upgrading, or making some changes in my.cnf file in Linux. The quickest way to this is by typing on the command line terminal. No fancy graphic interface.

MySQL Server Restart General Syntax

The syntax is as follows. On the Linux or OS X type the following on the shell prompt:
/etc/init.d/mysqld start
/etc/init.d/mysqld stop
/etc/init.d/mysqld restart

MySQL Server Restart Using Systemd Manager

Alternatively you could restart MySQL by sending control commands to the systemd manager.
systemctl start mysqld
systemctl stop mysqld
systemctl restart mysqld

FreeBSD Unix server users could use the following syntax to start/stop/restart the server.
/usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server restart

On OS X to start/stop/restart MySQL from the command line, as this article states
sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart


Leave a Reply

Your email address will not be published.

Related Posts

Linux System Administration

How to change ssh port

Advantages of Changing SSH Port First, I want to explain the reasons behind changing the ssh port of a server. Why changing ssh port when you have a strong password and/or a certificate? Additionally, it Read more…

Linux System Administration

SSH Hardening Techniques

SSH Hardening Techniques These are the top practices to harden ssh. In this article I am going to list the best and most important open ssh server security practices. SSH protocol is the best option Read more…

Linux System Administration

How To Use Public Key Authentication Instead Of Password

Password Login Belongs To The Past Public key authentication is an easier and more reliable compared to the old- fashioned password-based login. Keys are basically less prone to brute-force attacks. If you want to force Read more…