Bug #34487 mysql.servers table not created in Windows install

• Submitted: 12 Feb 2008 10:58
• Modified: 9 Jun 2008 15:12
• Reporter: Glynn Durham
• Status: Duplicate
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 5.1.22-rc-community
• OS: Windows
• Assigned to: Assigned Account
• CPU Architecture: Any

[12 Feb 2008 10:58] Glynn Durham

Description:
CREATE TABLE statement fails because mysql.servers table is missing.

How to repeat:
Install 5.1.22 on Windows.  Configure a new server and run it.

Log in to command line.

At mysql> prompt issue:

CREATE SERVER s FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'remote', HOST '192.168.1.106', DATABASE 'test');

You get:
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist

Suggested fix:
Create the mysql.servers table on install.

[12 Feb 2008 11:50] MySQL Verification Team

Thank you for the bug report.

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.22-rc-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE SERVER s FOREIGN DATA WRAPPER mysql
    -> OPTIONS (USER 'remote', HOST '192.168.1.106', DATABASE 'test');
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
mysql>

[24 Apr 2008 15:14] MySQL Verification Team

Bug: http://bugs.mysql.com/bug.php?id=36220 has been marked as duplicate of
this bug.

[9 Jun 2008 15:12] Iggy Galarza

Marked as a duplicate of 32797