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: | |
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
[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.