MySQL Bugs: #36220: Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

Bug #36220	Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Submitted:	20 Apr 2008 5:14	Modified:	25 Apr 2008 1:05
Reporter:	x zk	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	5.1.24	OS:	Windows (2003)
Assigned to:		CPU Architecture:	Any
Tags:	1045, Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist, error

Description:

MySQL5.1.24 installed at the time that the final step is always suggested that a mistake, and that what Connection Error 1045 ...... wrong, giant depressed ah. Later, the "D: \ MySQL \ Datafiles \ data" directory is a mistake to see the next document (***. err), said there "[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist. "So that is, re-establishing an yourself, the solution is simple. But each time re-built it too much trouble, or amend the document to install it.

How to repeat:

MySQL5.1.24 installed at the time that the final step is always suggested that a mistake, and that what Connection Error 1045 ...... wrong, giant depressed ah. Later, the "D: \ MySQL \ Datafiles \ data" directory is a mistake to see the next document (***. err), said there "[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist. "So that is, re-establishing an yourself, the solution is simple. But each time re-built it too much trouble, or amend the document to install it.

Suggested fix:

MySQL5.1.24 installed at the time that the final step is always suggested that a mistake, and that what Connection Error 1045 ...... wrong, giant depressed ah. Later, the "D: \ MySQL \ Datafiles \ data" directory is a mistake to see the next document (***. err), said there "[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist. "So that is, re-establishing an yourself, the solution is simple. But each time re-built it too much trouble, or amend the document to install it.

You are somewhat difficult to understand but I think the error 
"Table 'mysql.servers' doesn't exist" 
... tells that you did not run the mysql_upgrade program after upgrading the server to 5.1.24 (btw: from what version?).  

You always should execute 'mysql_upgrade' when upgrading, because the installer cannot do everything than is required when upgrading as it is not a client and cannot access the database (only the file system). 

Sometimes the system tables will need some change (CREATE, ALTER) when upgrading. That is what the mysql_upgrade program is for. You will get that table CREATED in the `mysql` database by the mysql_upgrade program.

(btw: I understand from this
http://monty-says.blogspot.com/2008/04/mysql-conference-good-bad-and-ugly.html
that the FEDERATED engine is not functional with 5.1.24 (the `servers` table is used by FEDERATED engine).  But still there maye be situations where the table is accessed or verified and an error will occur if it is non-existent)

Peter
(not a mysql person)

So, what version you had upgraded from? Had you tried to run mysql_upgrade program as suggested by Peter?

My mother tongue is not English, and English well, so I spent http://www.google.cn/language_tools this tool, my mother tongue into English, if I am not very good understanding have no alternative. Ha ha. . . . Makeshift makeshift bar. ^ V ^ 
Oh, first of all, if I upgrade, upgrade mysql should support, rather than to avoid escalation, if we do not support upgrading to write Mody,;) 
Second, I installed 5.1.24, I was to delete the previous version. Is a new installation.

Thank you for the bug report. Duplicate of bug http://bugs.mysql.com/bug.php?id=34487

Ha ha. Not continue to write. Only statements posted. : ( 
But the problem repeat. Oh My! From 5.1.22-rc-community version to 5.1.24 Zenmo have not yet been resolved. Mysql hope that the development of the staff quickly. Should not be disappointed. Mana speed. Think of this version 5.1.24 on the bug has not only for the basic version of this, it seems that still use the more stable 5.0 ah. 
When can solve ah » I resolved to tell out;) ah hope that the test efforts. This error so obvious.
==============
呵呵。不让继续写了。只能结贴了。:(
不过问题重复。天啊！从5.1.22-rc-community版本到5.1.24怎末还没有解决。希望mysql的开发人员快点了。要不该失望了。速度慢啊。想着5.1.24这个版本bug就基本没有了才换这个版本的，看来还是用5.0的比较稳定啊。
什么时候能解决啊？解决了告诉我一声;)希望测试人员努力啊。这个错误太明显了。