Dear list, 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
