Dear Jackson,
>shutdown. This problem arose today when I started tinkering with grant
privileges. But >doesn't make sense.
Try this: GRANT SHUTDOWN ON *.* TO the_one_who_can_shutdown@localhost
IDENTIFIED BY "some_shutdown_password"
Log on to the server admin tool like this:
mysqladmin -u the_one_who_can_shutdown -p shutdown
The MySQL server will prompt for the password, afterwards it will
shutdown.
You can grant the shutdown right to any MySQL user you want, e. g. for
"superuser", with GRANT ALL ON *.* ... etc.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "cjackson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 10:04 PM
Subject: I can kill it but Can't stop mysqld
> Thanks everyone for immediate response to this problem. I can kill the
mysql process but I cannot stop it using
> /etc/rc.d/init.d/mysqld stop. I can start it like this using start but
not stop it using stop. All of this is done as system root. So runlevel
3 starts it OK, but runlevel 5 won't stop it on shutdown. This problem
arose today when I started tinkering with grant privileges. But doesn't
make sense.
> Jackson
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
