New error WITH password implemented:
Script started on Sat Oct 2 16:28:59 2004 <command sent> This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func tables to MySQL 3.22.14 and above. This is needed if you want to use the new GRANT functions, CREATE AGGREGATE 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 an argument! Converting all privilege tables to MyISAM format ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'db' is read only ERROR 1036 at line 3: Table 'host' is read only ERROR 1036 at line 4: Table 'func' is read only ERROR 1036 at line 5: Table 'columns_priv' is read only ERROR 1036 at line 6: Table 'tables_priv' is read only 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 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'user' is read only Creating Grant Alter and Index privileges if they don't exists You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'host' is read only ERROR 1036 at line 3: Table 'db' is read only Setting default privileges for the new grant, index and alter privileges ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'db' is read only ERROR 1036 at line 3: Table 'host' is read only Adding columns needed by GRANT .. REQUIRE (openssl) You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 6: Table 'user' is read only 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 1036 at line 1: Table 'columns_priv' is read only Fixing the func table You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'func' is read only Adding new fields used by MySQL 4.0.2 to the privilege tables You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'user' is read only Updating new privileges in MySQL 4.0.2 from old ones ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 1: Table 'db' is read only ERROR 1036 at line 4: Table 'host' is read only ERROR 1036 at line 1: Table 'db' is read only ERROR 1036 at line 2: Table 'host' is read only ERROR 1036 at line 3: Table 'user' is read only ERROR 1036 at line 4: Table 'tables_priv' is read only ERROR 1036 at line 5: Table 'tables_priv' is read only ERROR 1036 at line 6: Table 'columns_priv' is read only ERROR 1036 at line 8: Table 'db' is read only ERROR 1036 at line 9: Table 'host' is read only ERROR 1036 at line 10: Table 'user' is read only ERROR 1036 at line 11: Table 'func' is read only ERROR 1036 at line 12: Table 'tables_priv' is read only ERROR 1036 at line 13: Table 'columns_priv' is read only doctor.nl2k.ab.ca//usr/contrib/var$ exit exit Script done on Sat Oct 2 16:29:27 2004 Say what?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]