MySQL Bugs: #51415: Documentation lists incorrect table for federated engine server connections

Bug #51415	Documentation lists incorrect table for federated engine server connections
Submitted:	23 Feb 2010 9:51	Modified:	24 Feb 2010 16:12
Reporter:	Nick Peirson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Tony Bedford	CPU Architecture:	Any

Description:
The documentation page http://dev.mysql.com/doc/refman/5.1/en/create-server.html lists the table that connections are stored in as mysql.server.

This table is actually mysql.servers, on 5.1.37 at least.

How to repeat:
Look at http://dev.mysql.com/doc/refman/5.1/en/create-server.html

Suggested fix:
s/mysql\.server/mysql.servers/

Thank you for the bug report. Verified just as described:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uroot -proot -P3310 mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.43-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> desc server;
ERROR 1146 (42S02): Table 'mysql.server' doesn't exist
mysql> desc servers;
+-------------+----------+------+-----+---------+-------+
| Field       | Type     | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+-------+
| Server_name | char(64) | NO   | PRI |         |       |
| Host        | char(64) | NO   |     |         |       |
| Db          | char(64) | NO   |     |         |       |
| Username    | char(64) | NO   |     |         |       |
| Password    | char(64) | NO   |     |         |       |
| Port        | int(4)   | NO   |     | 0       |       |
| Socket      | char(64) | NO   |     |         |       |
| Wrapper     | char(64) | NO   |     |         |       |
| Owner       | char(64) | NO   |     |         |       |
+-------------+----------+------+-----+---------+-------+
9 rows in set (0.01 sec)

So, documentation should be corrected.

Thanks for spotting this. The 5.1, 5.4, 5.5, and 6.0 reference manuals have been updated accordingly.