At 14:26 31/12/2002 +0100, Stefan Hinz, iConnect (Berlin) wrote: Hi,
Sorry but your issue is my fault. In the next release I will updateDear 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.
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
