I used mysqldump to recreate the a DB in another machine:
% mysqldump -A -u root --opt -p > backup.sql
But I guess that duplicates some columns in the mysql database, `cause
when want to add a new user to a new database:
mysql> grant all on some_db.* to [EMAIL PROTECTED] identified by 'pwd';
I get this:
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'some_db'
I've tried to fix the privileges table, but this is the output:
% /usr/local/bin/mysql_fix_privilege_tables --verbose --password=password
ERROR 1060 at line 19: Duplicate column name 'File_priv'
ERROR 1060 at line 32: Duplicate column name 'Grant_priv'
ERROR 1060 at line 33: Duplicate column name 'Grant_priv'
ERROR 1060 at line 34: Duplicate column name 'Grant_priv'
ERROR 1060 at line 45: Duplicate column name 'ssl_type'
ERROR 1054 at line 84: Unknown column 'Type' in 'columns_priv'
ERROR 1060 at line 90: Duplicate column name 'type'
ERROR 1060 at line 100: Duplicate column name 'Show_db_priv'
ERROR 1060 at line 117: Duplicate column name 'max_questions'
ERROR 1060 at line 127: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 at line 130: Duplicate column name 'Create_tmp_table_priv'
ERROR 1061 at line 138: Duplicate key name 'Grantor'
ERROR 1060 at line 150: Duplicate column name 'Create_view_priv'
ERROR 1060 at line 151: Duplicate column name 'Create_view_priv'
ERROR 1060 at line 152: Duplicate column name 'Create_view_priv'
ERROR 1060 at line 157: Duplicate column name 'Show_view_priv'
ERROR 1060 at line 158: Duplicate column name 'Show_view_priv'
ERROR 1060 at line 159: Duplicate column name 'Show_view_priv'
done
What can I do?
Is there a way to fix this?
Thanks a lot in advance.
Regards,
Ed
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
