How Do I Restart MySQL Server?
Each distribution comes with shell script (read as service) to restart 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 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.
Related posts (skip to comment)
Tags: /etc/init.d/mysqld start, command prompt, debian linux, fedora core, init, linux distro, linux fedora, linux fedora core, linux os, linux shell, mysql linux, mysql server, mysqladmin restart, open shell, redhat linux, root user, shell script
9 comments
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
try the other commands -
# service mysqld start
# service mysqld stop
# service mysqld restart
These usually work for me
Thanks a lot for this! I really helped me out.
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
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
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.0Type the following to start:
/etc/init.d/mysql startMany thanx!
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
What’s about Darwin with the ‘launchd’ installed? How do I restart mysql?
Leave a Comment