mysql_fix_privilege_tables error

--Apple-Mail-7-168635766
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

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
--Apple-Mail-7-168635766--

Re: mysql_fix_privilege_tables error

Does the root user have full permissions? You'll need more than grant if you
are going to run this script.

-Micah


On Tuesday 13 September 2005 3:56 pm, Carson Au wrote:
> 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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysql_fix_privilege_tables error

Now that I'm looking at it, it just seems that the password was wrong, or you
no longer have a root user (which you shouldn't if the database has been in
use.. )

You may need to re-create it?

Can you log in like this:

mysql -u root -p

using that same password?

-Micah

On Tuesday 13 September 2005 3:56 pm, Carson Au wrote:
> 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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysql_fix_privilege_tables error

In article <2aa45257a171d7cd43ee19625a4be13a@sfu.ca>,
cau@sfu.ca (Carson Au) wrote:

> 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

Hi, I'm using MySQL 4.0.28. The syntax that finally worked for me was:

mysql_fix_privilege_tables --password='my_password'

The single quotes around the password seem mandatory!

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php