mysql_fix_privilege_tables error

From: Date: Tue, 13 Sep 2005 22:56:47 +0000
Subject: mysql_fix_privilege_tables error
Groups: php.db 
Request: Send a blank email to php-db+get-40261@lists.php.net to get a copy of this message
Hi Guys, I am a newbie and having a lot of trouble with PHP/MySQL lately... We have a number of PHP/MYSQL solutions developed on our server and I have the pleasure to maintain them... The copy of MySQL 3.23 has started crashing and refusing to start, so what I did was I backed up all the DBs and then reinstalled version 4, things seems to be working ok. Then I discovered this: http://www.educ.sfu.ca/phpbb2/ and in phpmyadmin I get this message: "Warning: Your privilege table structure seem to be older than this MySQL version! Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!" So I tried to do the following... $ sudo -s $ mysql_fix_privilege_tables mypassword And this is the errors I got: 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! 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 1045: Access denied for user: 'root@localhost' (Using password: YES) Creating Grant Alter and Index privileges if they don't exists You can ignore any Duplicate column errors ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Creating the new table and column privilege tables ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Changing name of columns_priv.Type -> columns_priv.Column_priv You can ignore any errors from this ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Fixing the func table You can ignore any Duplicate column errors ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Any suggestion? I have checked the permission table using phpmyadmin and grant=Yes for "root". Anything else I need to do differently? Regards, Cars

« previous php.db (#40261) next »