Ian,
Tuesday, April 23, 2002, 12:41:40 AM, you wrote:
Egor>> By default user 'root' has all privileges...
Egor>> Show me the output of following:
Egor>> SHOW GRANTS FOR 'root'@'localhost';
IP> mysql> show grants for 'root'@'localhost'
IP> -> ;
IP> +---------------------------------------------------------------------------
IP> ------------------+
IP> | Grants for root@localhost
IP> |
IP> +---------------------------------------------------------------------------
IP> ------------------+
IP> | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
IP> 'password_obscured' |
IP> +---------------------------------------------------------------------------
IP> ------------------+
IP> 1 row in set (0.00 sec)
:)
Your 'root' user doesn't have GRANT privilege ...
You should change Grant_priv to 'Y'
You can do this using UPDATE statement:
UPDATE user SET Grant_priv='Y' WHERE user='root';
or you run mysqld with "--skip-grant-tables" option and set Grant_priv
using GRANT statement:
GRANT ALL ON *.* to 'root'@'localhost' identified by
'password_obscured' WITH GRANT OPTION;
IP> Ian
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
