How to start / stop the MySQL service

[blossam]

hi,
i want to shutdown mysql service n after that i want to start it
i m using
mysqladmin -u root shutdown command to stop service
now i want to start it using command do u know which command i can use to start mysql after shutdown it

[bartonc]

hi,
i want to shutdown mysql service n after that i want to start it
i m using
mysqladmin -u root shutdown command to stop service
now i want to start it using command do u know which command i can use to start mysql after shutdown it

Check out the manual: 5.2.2. Command Options.

Also, I notice that you are on Windows.
In the Start menu, under MySQL go to the MySQL Server x.x | MySQL Server Instance Configuration Wizard. There you will find an option to start the service when Windows boots up.

[Atli]

Hi.

If you are using Windows, you can start and stop the MySQL service just like any other service.
Open a cmd window and type:

net stop MySQL
net start MySQL

Where MySQL is the name of the MySQL service.

On Linux you can do something like this:

# /etc/init.d/mysqld start
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld restart

Fedora / Red Hat also support this:

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

P.s. I edited the title to make it a little clearer.

[blossam]

Hi.

If you are using Windows, you can start and stop the MySQL service just like any other service.
Open a cmd window and type:

net stop MySQL
net start MySQL

Where MySQL is the name of the MySQL service.

On Linux you can do something like this:

# /etc/init.d/mysqld start
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld restart

Fedora / Red Hat also support this:

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

P.s. I edited the title to make it a little clearer.

thanks 4 help me. i really need this

[Kiraa]

yes really Thx it helps and it's Simple .... thx