Restart MySQL Server

Author: Vivek Gite Last updated: December 27, 2013 11 comments

I am a new FreeBSD version 6.x/7.x/8.x/9.x/10.x server user. How do I start / stop or restart MySQL server from a shell prompt over ssh session?

First login as the root user. Next make sure MySQL service is enabled. Just open /etc/rc.conf file using vi text editor:
# vi /etc/rc.conf

Append / modify following line to start MySQL service:
mysql_enable="YES"

Save and close the file.

Task: Start MySQL server on FreeBSD

Type the following command:
# /usr/local/etc/rc.d/mysql-server start

Type the following command:
# /usr/local/etc/rc.d/mysql-server stop

Type the following command:
# /usr/local/etc/rc.d/mysql-server stop && /usr/local/etc/rc.d/mysql-server start

🐧 Get the latest tutorials on Linux, Open Source & DevOps via RSS feed or Weekly email newsletter.

🐧 11 comments so far... add one ↓

Related Tutorials

Category	List of Unix and Linux commands
Disk space analyzers	ncdu • pydf
File Management	cat
Firewall	Alpine Awall • CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04
Network Utilities	NetHogs • dig • host • ip • nmap
OpenVPN	CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04
Package Manager	apk • apt
Processes Management	bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time
Searching	grep • whereis • which
User Information	groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w
WireGuard VPN	Alpine • CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04

11 comments… add one

chat Oct 3, 2008 @ 0:31

Thank you. i need this command.

Reply Link
GB Jun 25, 2009 @ 17:43

God tip.
Thanks!

Reply Link
KAZEEM ADEDOKUN Jul 30, 2009 @ 17:06

pls. i need more about mySQL method of setting and resetting

Reply Link
Beginner Aug 20, 2009 @ 15:38

Appreciated.

Reply Link
Vorbis Jan 27, 2010 @ 17:20

As always, phenomenal tips from nixcraft. Every single problem I have ever had with freeBSD this site has solved! 5/5

Reply Link
Linux techie May 18, 2010 @ 12:48

Very useful info. Could you please tell me how to configure the MySQL server to work with PHP. I have just installed and started.

Reply Link
Rob Nov 22, 2011 @ 1:36

I had to add the following to /etc/rc.conf for this to work:

mysql_enable=”YES”
mysql_args=”–user=mysql”

Reply Link
informatty Jan 30, 2012 @ 13:04

Cool! It runned cool for me !

Reply Link
kent Dec 27, 2013 @ 16:55

/usr/local/etc/rc.d/mysql-server restart

Reply Link
Laki Sep 7, 2014 @ 22:13

If you don’t like starting mysql from /usr/local/etc/rc.d/ and service won’t work like this :

# service mysql status
mysql does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d)

You can make symlink

ln -s /usr/local/etc/rc.d/mysql-server mysql

This way you can use

# service mysql status
mysql is running as pid 5023.

# service mysql restart
Stopping mysql.
Waiting for PIDS: 5023.
Starting mysql.

Reply Link
Laki Sep 7, 2014 @ 22:14

Assuming you are in /etc/rc.d

Reply Link