≡ Menu

FreeBSD Start / Stop / Restart MySQL Server

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?

Tutorial details
DifficultyEasy (rss)
Root privilegesYes
Estimated completion time1m
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:

Save and close the file.

Task: Start MySQL server on FreeBSD

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

Task: Stop MySQL server on FreeBSD

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

Task: Restart MySQL server on FreeBSD

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

Tweet itFacebook itGoogle+ itPDF itFound an error/typo on this page?

{ 11 comments… add one }

  • chat October 3, 2008, 12:31 am

    Thank you. i need this command.

  • GB June 25, 2009, 5:43 pm

    God tip.

  • KAZEEM ADEDOKUN July 30, 2009, 5:06 pm

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

  • Beginner August 20, 2009, 3:38 pm


  • Vorbis January 27, 2010, 5:20 pm

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

  • Linux techie May 18, 2010, 12:48 pm

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

  • Rob November 22, 2011, 1:36 am

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


  • informatty January 30, 2012, 1:04 pm

    Cool! It runned cool for me !

  • kent December 27, 2013, 4:55 pm

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

  • Laki September 7, 2014, 10:13 pm

    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.

  • Laki September 7, 2014, 10:14 pm

    Assuming you are in /etc/rc.d

Leave a Comment