Marty

Well-Known Member
Oct 10, 2001
629
1
318
I am getting this in my upcp email ever day now:

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


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'
ERROR 1060 at line 2: Duplicate column name 'Grant_priv'
ERROR 1060 at line 3: Duplicate column name 'Grant_priv'


Setting default privileges for the new grant, index and alter privileges


Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1060 at line 1: Duplicate column name 'ssl_type'


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
ERROR 1060 at line 1: Duplicate column name 'Show_db_priv'


Updating new privileges in MySQL 4.0.2 from old ones


ERROR 1060 at line 1: Duplicate column name 'max_questions'
ERROR 1060 at line 1: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 at line 4: Duplicate column name 'Create_tmp_table_priv'
Is there any reason for this to continue?
 

DigitalKNK

Member
Mar 30, 2003
11
0
151
Sothern California, USA
I been wondering myself why that is happening. I already ran the commands needed to "update/fix" the databases for mysql 4 ... so I am wondering myself why this keeps poping up in my emails as well.