PDA

View Full Version : Stopping MySQL


laram
06-05-2002, 12:37 AM
I got some great advice on this forum about how to start MySQL using the command line. Now that I can get it started, does any one know how to shut MySQL 3.23.49 down? I tried using the 'mysqladmin shutdown' command and all I get is this...

'./bin/mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)''

What's the deal? By the way (in case it matters), I'm running in Mac OS 10.1.4.

laram
07-31-2002, 09:59 AM
Well, so much for getting more great advice. Here I am several weeks later and I've finally learned how to stop MySQL (I read it in PHP and MySQL for Dummies). I was correct in trying to use the 'mysqladmin shutdown' command but I didn't realize that there was more to it than 'mysqladmin shutdown'. The actual command should go like this...

mysqladmin -u accountname -p shutdown

Here accountname is the name of an account with shutdown permission (like root). You will then be prompted for a password. If you have not set MySQL to require a password then you do not have to include '-p' in the command.