Probleme de mise à jour de MySQL

[redpooka]

Je suis sous MySQL 3.23.49, et je veux passer à la version 4.0. <BR>Or quand j'utilise cette commande Code: <BR>mysql_fix_privilege_tables monmotdepasse <BR> <BR> <BR>J'obtient ce message d'erreur <BR> <BR>

Code: Tout sélectionner

<BR>This scripts updates the mysql.user, mysql.db, mysql.host and the <BR>mysql.func table to MySQL 3.22.14 and above. <BR> <BR>This is needed if you want to use the new GRANT functions, <BR>CREATE AGGREAGATE FUNCTION or want to use the more secure passwords in 3.23 <BR> <BR>If you get Access denied errors, you should run this script again <BR>and give the MySQL root user password as a argument! <BR> <BR>If your tables are already up to date or partially up to date you will <BR>get some warnings about 'Duplicated column name'. You can safely ignore these! <BR>ERROR 1060 at line 2: Duplicate column name 'File_priv' <BR> <BR>Creating Grant Alter and Index privileges if they don't exists <BR>You can ignore any Duplicate column errors <BR>ERROR 1060 at line 1: Duplicate column name 'Grant_priv' <BR> <BR>Creating the new table and column privilege tables <BR>Changing name of columns_priv.Type -> columns_priv.Column_priv <BR>You can ignore any errors from this <BR>ERROR 1054 at line 1: Unknown column 'Type' in 'columns_priv' <BR>Fixing the func table <BR>You can ignore any Duplicate column errors <BR>ERROR 1060 at line 1: Duplicate column name 'type' <BR>

<BR> <BR>Et je reste toujours à la version 3.23.49. Où est l'erreur ? Que modifier ? <BR> <BR>Merci