Rob, Thursday, March 14, 2002, 10:15:54 PM, you wrote: >>Show me the output of the following: >> SHOW GRANTS FOR 'username'@'hostname';
RQ> output: RQ> mysql> show grants for 'root@localhost'; RQ> ERROR 1064: You have an error in your SQL syntax near RQ> 'grants for 'root@localhost'' at line 1 RQ> I noticed that my user table doesn't seem to have all the fields RQ> it should. I upgraded from an older version of mysql back in November. RQ> There are 4 fields missing (Grant_priv, References_priv, RQ> Index_priv, Alter_priv). I just read on www.mysql.com that I RQ> need to run mysql_install_db. I assume this will alter the table RQ> structure to include the new fields, but will it also mess up my RQ> previously defined users? It'a a very strange situation. You can run install mysql_install_db but you should first move old privileges tables from mysql data dir. You can read about running mysql_install_db at: http://www.mysql.com/doc/m/y/mysql_install_db.html After running mysql_install_db you will get new privileges table with user 'root' without a password and default anonymous user. You can also start mysqld with '--skip-grant-tables' option and re-create missing columns using ALTER TABLE statement to add those missing columns: `Grant_priv` enum('N','Y') NOT NULL default 'N', `References_priv` enum('N','Y') NOT NULL default 'N', `Index_priv` enum('N','Y') NOT NULL default 'N', `Alter_priv` enum('N','Y') NOT NULL default 'N' RQ> Rob -- 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