How Do I Restart MySQL Server?

Each distribution comes with a shell script (read as service) to restart / stop / start MySQL server. First login as root user and open shell prompt (command prompt).

First login as root user. Now type the following command as per your Linux distro:

A) If you are using mysql on RedHat Linux (Fedora Core/Cent OS) then use following command:

* To start mysql server:

/etc/init.d/mysqld start

* To stop mysql server:

/etc/init.d/mysqld stop

* To restart mysql server

 /etc/init.d/mysqld restart

Tip: Redhat Linux also supports service command, which can be use to start, restart, stop any service:

# service mysqld start
# service mysqld stop
# service mysqld restart

(B) If you are using mysql on Debian / Ubuntu Linux then use following command:

* To start mysql server:

/etc/init.d/mysql start

* To stop mysql server:

/etc/init.d/mysql stop

* To restart mysql server

/etc/init.d/mysql restart

More MySQL articles are here and here.

Meet the Author

Admin

I like chocolate, gadgets, open source software, photography, traveling and all shades of green colors. I love spending time with fun loving friends and family members. This is my own online journal.

38 comments… add one
  • sharath Mar 17, 2007, 10:59 am

    hi
    i am new to linux and i have to stop the mysqld service so as to install bugzilla … i have tried the following cmds but they have failed
    /etc/init.d/mysqld stop
    i am using redhat os

  • Tim May 28, 2007, 4:19 am

    try the other commands –

    # service mysqld start
    # service mysqld stop
    # service mysqld restart

    These usually work for me

  • imp Jul 12, 2007, 5:53 pm

    Thanks a lot for this! I really helped me out.

  • mud Sep 15, 2007, 3:20 am

    hi
    iam using centos 5.0 and ihave problem with mysql
    mysql cant connect
    i have try to restart n all command which u show on your web but its unsuccesfull
    can tell me why..?n what can i do to get mysql back like before
    thanks

  • Al May 15, 2008, 8:47 am

    Hi,
    I’m really embarrased to ask this, but I’m really new to linux + mysql. I installed mysql following the proceadure in http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html, then I try to run your restart command and I get: -bash: /etc/init.d/mysql: No such file or directory.
    I’m using mysql 5.0 over Debian… I’m sure I missed some configuration little detail, what can it be?
    Any response is well appreciated :)
    Al

  • vivek May 15, 2008, 11:04 am

    mysqld_safe is the recommended way to start a mysqld server if you install it from source or mysql.com:
    mysqld_safe &

    The correct method to install it via apt-get under Debian and Ubuntu Linux. Type the following to install
    apt-get install mysql-server-5.0 mysql-client-5.0
    Type the following to start:
    /etc/init.d/mysql start

  • Al May 16, 2008, 12:28 pm

    Many thanx! :D

  • Jack May 26, 2008, 1:24 pm

    Hi thanks for this site, I sometimes have to restart the mysqld server myself, when it hangs. So this is really helpful, best result on google :)

  • yury Aug 27, 2008, 7:33 am

    What’s about Darwin with the ‘launchd’ installed? How do I restart mysql?

  • Dom-2000 May 12, 2009, 1:32 pm

    You can also use:
    # kill mysqld
    .. wait till it shuts down – you can check by
    # ps ax | grep mysql
    then start it:
    # cd /usr/local/mysql/bin (or where your mysql is installed)
    # ./mysqld_safe &

  • Rowena May 25, 2009, 2:23 am

    For fedora, You must start mysqld everytime you boot up your pc, using /etc/init.d/mysqld start
    If you stop without knowing it is starting it will show errors, you must start first, ok?

  • mp3 Aug 2, 2009, 4:39 am

    Thanks a lot.

  • phyp Aug 22, 2009, 3:11 am

    Hey thanks a lot,

    Very very useful post.

  • Douglas Sep 14, 2009, 2:59 pm

    you use the comand top
    and see all process and look,
    what procces using more Memory and use killall nameprocess or kill pid process

  • Muntasir Oct 4, 2009, 9:24 am

    Hi, everyone. I’ve developed a project in php which requires one shell file as backup/output, one same file – manually updated. Between these two shell files if anyone is changed, the newer should update the older one. I’ve done it already by shell script but after the update process I need to restart the service I’m working on. I know the terminal command which is “/etc/init.d/service_name restart” but when I put this in my shell file it doesn’t work. Everything else are working but not the restart command. Can anyone help me out? Thanks in advance.

  • Ihsanullah Oct 28, 2009, 6:55 am

    Thanks, very works for me.

  • Luis Dec 22, 2009, 11:57 pm

    It saved my day. I know nothing about mysql and I hade to restart one!

  • Rosario Feb 10, 2010, 12:00 pm

    I use /etc/init.d/mysqld restart in RedHat Linux and i dont had any problem

  • Anonymous Feb 27, 2010, 2:29 pm

    chkconfig –level 345 mysql on
    will autostart mysql on fedora systems.

  • NMN Mar 23, 2010, 9:49 am

    I have got a problem with MySQL. I can’t connect to the server, get the message: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

    I am running Kubuntu 9.10,

    I had moved my MySQL database from my stationary PC to my laptop. Everything seemed to function OK, but so I got the preceding error message both from MySQL Navigator, Knoda and trying to connect from the terminal window. Restarting the server didn’t help. Where to search for the error? I am new to MySQL.

  • Coolege Mar 23, 2010, 1:39 pm

    you are my hero, now I know how to restart mysql… it also works the same for apache2 :)

  • K.Anurathan May 19, 2010, 6:56 am

    how to start the server with password???
    when i used these commands i got it!
    _________________________________________________________
    administrator@administrator-desktop / $ /etc/init.d/mysql start
    * Starting MySQL database server mysqld
    cat: /var/run/mysqld/mysqld.pid: Permission denied
    ——————————————————————————————-

    Is there any suitable commands?….

  • shiva Jul 7, 2010, 7:56 am

    how to start . then system is started then my sqld , tomcat services are start give me advice

  • suganthi Aug 4, 2010, 6:50 am

    Hi everyone,

    when i tried to restart mysql server i got the error as “Access denied for user@localhost” then i tried to run mysql script externally,
    cd /etc/init.d/
    ./mysql restart
    it works,.. mine is linux ubuntu 9.04 Debian based

  • smapan Aug 5, 2010, 1:19 am

    thank you verymuch

  • aaron Aug 13, 2010, 9:07 pm

    I have somehow lost all permissions on root and don’t currently have any other users. This is troublesome because I don’t have the privileges to give myself privileges or create new users. I also don’t know how to start the mysql program with –skip-grant-tables, or I would try this. Any help would be great.

  • casino Aug 16, 2010, 10:51 pm

    thanks all ok!

  • munna Oct 6, 2010, 4:05 pm

    i am using fedora 13 . one problem with me is mysql is not start by using the command /etc/init.d/mysqld start if i use thid command then showing the message Command not found. Similar command is: ‘mysql’
    please solve my problem……….

  • Daniel T Oct 12, 2010, 5:13 am

    Sounds like you only have a part of MySQL installed, you also need the client.
    Try ‘sudo apt-get install mysql-client-5.1’

    and then follow the steps mentioned above to start. During the install you should be prompted for setting the MySQL password etc.

  • Aji Prabowo Mar 31, 2011, 5:32 am

    Great info.
    Sharing is power.

    thanks,

  • Eddie Mar 31, 2011, 6:42 pm

    Can’t locate mysqld and mysqladmin after deploying from rpm package. I can’t deploy rpm without using root. So can anyone help me? It keeps saying cannot start mysql on root, asked to check security part in the manual. But can’t search manual because it has error. Can someone help?

  • Lelik Oct 19, 2011, 12:59 am

    thanx much!

  • sysadmin Jan 5, 2012, 12:53 pm

    Does anybody knows what is the difference between “/etc/init.d/mysqld restart” and “/etc/init.d/mysqld reload”?

  • evans Feb 2, 2012, 8:49 am

    Hi

    I find it difficult to start mysql

  • Tyrotoxism Mar 2, 2012, 4:30 pm

    Don’t forget:
    $ service mysql start
    $ service mysql stop
    $ service mysql restart
    These worked for me, at least.

  • Vijay May 6, 2012, 5:56 am

    thanks a bunch. my EC2 server was acting up and all it needed was a quick restart.

  • Vijay May 6, 2012, 5:57 am

    @Tyrotoxism

    For me the shortcut is
    $ service mysqld start
    $ service mysqld stop
    $ service mysqld restart

  • Mau Aug 25, 2012, 6:23 am

    Thank you! my home server was stuck and my wordpress said something like “database error”. Your post solved the problem!

Leave a Comment