Re: Privileges in MySQL 4.0.7 (upgrade)
Dear list, no one has answered my question up to now. Looking through the manual again today, I still can't figure out what to do. just upgraded from MySQL 4.0.3 to 4.0.7 on my Win2K box at home. The problem is, I still have the _old_ privileges in my mysql tables, not the new ones like super, show database etc. All the manual (and the user notes) are telling me is that I have to run the mysql_fix_privilege_tables script. But where can I find it? It's not in the MySQL Windows distribution. 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: Stefan Hinz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 12:03 AM Subject: Privileges in MySQL 4.0.7 (upgrade) 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 - 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
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
Re: Privileges in MySQL 4.0.7 (upgrade)
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
Re: Privileges in MySQL 4.0.7 (upgrade)
At 14:26 31/12/2002 +0100, Stefan Hinz, iConnect (Berlin) wrote: Hi, Dear list, no one has answered my question up to now. Looking through the manual again today, I still can't figure out what to do. Sorry but your issue is my fault. In the next release I will update the tables. In the meantime you should do the following: - I send for you the tables on separate e-mail. or You install Cygwin in your machine and I send for you the mysql_fix_privilege_tables.sh script in separate e-mail. Edit the @bindir@ changing for your path, for example I did: /home/Administrador. Copy the mysql.exe client to this directory. Run the server. Run the below command e.g.: Administrador@LIGHT ~ $ ./mysql_fix_privilege_tables.sh This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func table to MySQL 3.22.14 and above. This is needed if you want to use the new GRANT functions, CREATE AGGREAGATE FUNCTION or want to use the more secure passwords in 3.23 If you get Access denied errors, you should run this script again and give the MySQL root user password as a argument! Converting all privilege tables to MyISAM format If your tables are already up to date or partially up to date you will get some warnings about 'Duplicated column name'. You can safely ignore these! ERROR 1060 at line 2: Duplicate column name 'File_priv' Creating Grant Alter and Index privileges if they don't exists You can ignore any Duplicate column errors ERROR 1060 at line 1: Duplicate column name 'Grant_priv' Adding columns needed by GRANT .. REQUIRE (openssl) You can ignore any Duplicate column errors Creating the new table and column privilege tables Changing name of columns_priv.Type - columns_priv.Column_priv You can ignore any Unknown column errors from this ERROR 1054 at line 1: Unknown column 'Type' in 'columns_priv' Fixing the func table You can ignore any Duplicate column errors ERROR 1060 at line 1: Duplicate column name 'type' Adding new fields used by MySQL 4.0.2 to the privilege tables You can ignore any Duplicate column errors Updating new privileges in MySQL 4.0.2 from old ones -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ 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
Privileges in MySQL 4.0.7 (upgrade)
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