Bug #31596 error running mysql_fix_privileges on 5.1.22 Win

• Submitted: 15 Oct 2007 8:17
• Modified: 24 Oct 2007 12:39
• Reporter: Sebastian Mendel (Basic Quality Contributor)
• Status: Can't repeat
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: 5.1.22
• OS: Windows (XP Pro SP2)
• CPU Architecture: Any

[15 Oct 2007 8:17] Sebastian Mendel

Description:
Looking for 'mysql.exe' in: C:\Programme\MySQL\MySQL Server 5.1\bin\mysql.exe
Looking for 'mysqlcheck.exe' in: C:\Programme\MySQL\MySQL Server 5.1\bin\mysqlcheck.exe
Running 'mysqlcheck'...
[...]
Running 'mysql_fix_privilege_tables'...
ERROR 1193 (HY000) at line 68: Unknown system variable 'have_csv'
ERROR 1064 (42000) at line 70: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 71: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 72: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1193 (HY000) at line 76: Unknown system variable 'have_csv'
ERROR 1064 (42000) at line 78: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 79: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 80: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
FATAL ERROR: Upgrade failed

How to repeat:
C:\Programme\MySQL\MySQL Server 5.1>.\bin\mysql_upgrade.exe -pXXX

[15 Oct 2007 8:22] Sebastian Mendel

sorry, my fault again, a 5.0 server was running when i tried to execute the above,  it would be nice if there could be a check if the right server (the binary from the same directory) is running, or at least some sort of warning ...

[24 Oct 2007 12:39] MySQL Verification Team

Thank you for the bug report.

[7 Dec 2007 2:19] Li Qian

I have a similar case when upgrade mysql from v5.0.45 to v5.1.21 

#mysql_upgrade -p
Enter password:
Looking for 'mysql' in: mysql
Looking for 'mysqlcheck' in: mysqlcheck
Running 'mysqlcheck'...
Running 'mysql_fix_privilege_tables'...
ERROR 1193 at line 68: Unknown system variable 'have_csv'
ERROR 1064 at line 70: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 at line 71: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 at line 72: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1193 at line 76: Unknown system variable 'have_csv'
ERROR 1064 at line 78: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 at line 79: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 at line 80: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
FATAL ERROR: Upgrade failed

my platform:  AIX 5.3.0.0_TL_06

[31 Mar 2008 16:19] Thierry Tisserand

Can you tell me if a patch exists ?

Thanks

[1 Apr 2008 14:54] Thierry Tisserand

i find a solution

i have deinstall the service Mysql :
"mysqld --remove"
and i install again the service myql
"mysqld --install mysql --defaults-file=...."
then
mysql_upgrade.exe -uroot -p<password>

That's all

[13 Sep 2008 13:30] MySQL Verification Team

Verify that the server you have started is really 5.1 (login and issue SELECT VERSION();), especially if you are installing 5.1 to a different location than your 5.0 version and it's at all possible that the 5.0 binary still exists and is started by mistake.