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) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.1.22 OS:Windows (XP Pro SP2)
Assigned to: 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.