Having trouble shutting down my MySQL server.

[Stephen Philbin]

Well as the title says, I'm having problems shutting down my MySQL server. I was using ./mysql -u root shutdown (whilst in a root console sitting in /usr/local/mysql/bin) during testing it out, but now that I have set a password to the user, I can't get the bugger to go down.

I did try ./mysql -u root shutdown -p (and many other variants) but most of the time I just get either the list I would get from ./mysql --help or it just tells me that there's no server called "shutdown" :/

Any help folks?

[Paul Jr]

I'm on a Windows box, but when in the mysql/bin directory, I was able to shut down MySQL via: mysqladmin -u root -p. I was promted for the password, and then MySQL was shutdown.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\WINDOWS\system32>d:

D:\>cd mysql/bin

D:\mysql\bin>mysqladmin -u root shutdown -p
Enter password: ******

D:\mysql\bin>

Alternately, I could have just done: d:\mysql\bin\mysqladmin -u root shutdown -p rather than moving to the /bin directory.

[Stephen Philbin]

Ah yeah. Just forgetting the admin bit Like a bell-end. Nice one Paul. :D


Excuse me whilst I slap myself in a corner for a while.........

[Paul Jr]

Heh, no problem. :D

Don't slap yourself too hard; it might scar. :p