How to properly kill/restart Mysql if my.cnf changed?

[ubbuser]

Hello, if I change a value in my.cnf, how do I properly kill mysql?

I ask this because even if I type:

mysqladmin shutdown

Then I do a ps aux | grep mysql

and I see mysql_safe running!

so what is the best way to make sure mysql is shutdown?

also I restart using the init.d script that has mysql script and I just do a mysql start

Is that fine?

Any help would be appreciated much! Thanks in advance!

[Freddie Bingham]

You can restart mysql from phpMyAdmin or you can usually issue (when su'd to root)

/etc/rc.d/init.d/mysql stop
/etc/rc.d/init.d/mysql start

[eva2000]

i do the way freddie says, but sometimes mysql will linger for a while before ending so do a

ps aux | grep mysql

to see when mysql ends before touching your database in the case for mysql repairs etc

[Dave#]

Originally posted by freddie
You can restart mysql from phpMyAdmin or you can usually issue (when su'd to root)

/etc/rc.d/init.d/mysql stop
/etc/rc.d/init.d/mysql start

Not be a pedant but that will only work on Linux (not unix), and only if the startup scripts have been installed.


http://www.mysql.com/doc/A/u/Automatic_start.html