Dear Thomas, > you may want to take the queries from the > mysql_fix_privilege_tables shell script and run them > manually.
Thanks! If only I could find this script ... Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Thomas Spahni" <[EMAIL PROTECTED]> To: "Stefan Hinz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, December 31, 2002 2:58 PM Subject: Re: Privileges in MySQL 4.0.7 (upgrade) Stefan, you may want to take the queries from the mysql_fix_privilege_tables shell script and run them manually. All queries are nice and clean in the script and can be extracted with any editor. Thomas Spahni On Tue, 31 Dec 2002, Stefan Hinz wrote: > just upgraded from MySQL 4.0.3 to 4.0.7 on my Win2K box at home. Leaving > DATADIR as it was, the 4.0.7 installation did not touch the privilege > tables in the mysql database, so I did not have the new privileges and > features available. > > As there doesn't seem to be a mysql_fix_privilege_tables script for > Win2K, I wiped out my old mysql database (pressing DEL in Win Explorer), > and installed again. This gave me a new mysql database, but no new > privileges at all. My old user accounts are gone, though, so the > installation procedure definitely set up something new. > > DESCRIBE host; DESCRIBE user; DESCRIBE db; shows me that features like > "Create_tmp_table_priv" and "Super_priv" are still missing. The most > "modern" feature I can find is the "References_priv". > > Win Explorer tells me the mysql database is from 2002-12-30 (today), but > all the tables in there are from 2001-10-06. I took down the server when > installing the update, and I put a copy of my old DATADIR on another > disk. > > Any hints are greatly appreciated. > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > > > --------------------------------------------------------------------- > 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
