Bug #6320 Error by mysql_fix_privilege_tables

• Submitted: 29 Oct 2004 13:34
• Modified: 11 Jan 2005 18:28
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 4.1.7
• OS: FreeBSD (freebsd)
• Assigned to: Timothy Smith
• CPU Architecture: Any

[29 Oct 2004 13:34] [ name withheld ]

Description:
I have updated my mysql from 4.0.21 to 4.1.7. I get error when i want do the command  mysql_fix_privilege_tables. This is what I get:
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/local/bin/mysql -f --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option

I have reached on the site, but I haven't the solution

How to repeat:
I have updated my mysql from 4.0.21 to 4.1.7. I get error when i want do the command  mysql_fix_privilege_tables. This is what I get:
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/local/bin/mysql -f --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option

I have reached on the site, but I haven't the solution

[29 Oct 2004 21:51] Timothy Smith

Hi!  Did you install MySQL 4.0.21 from the ports, or did you download our binaries?  Did you use a LinuxThreads version or native FreeBSD threads?

The same questions for the 4.1.7 upgrade - did you use /usr/ports, a package, or a binary tarball downloaded from our site?

Also, please try this sequence of commands:

$ script
$ mysql_fix_privilege_tables --verbose --password='your db password'
$ exit
$ 

Then please send me 'typescript' file that is in that directory.  You can attach it as a File to this bug report.

Thank you,

Timothy

[30 Oct 2004 7:45] [ name withheld ]

I have installed form the ports en also for updating to 4.1.7. Yesterday I have downgrade this version to 4.0.21 because it was on the production server. So I can't send that file

Rachid

[31 Oct 2004 21:46] Timothy Smith

OK, I will try to reproduce this using just the FreeBSD ports.  -- Timothy

[1 Nov 2004 12:18] [ name withheld ]

I have tested on my machine. I have updated from mysql 4.1.6-gamma to 4.1.7 and get the same problem. On mysql 4.1.6-gamma it works fine.

[11 Jan 2005 18:28] Timothy Smith

I tried to repeat this with the latest ports tree on a new FreeBSD, and I can't.  If someone can give me exact details on how you produce this problem, let me know.  i tried using the ports tree to install mysql40-server and then upgrade to mysql41-server.

Thanks,

Timothy

[11 Jan 2005 18:59] [ name withheld ]

Timothy,

You can close this bug. I have now 4.1.8a and it's working great.

Thanks,

Rachid