Bug #25676 information on federated server missing
Submitted: 17 Jan 2007 10:17
Reporter: Giuseppe Maxia Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S4 (Feature request)
Version:5.1.15 OS:Any (all)
Assigned to: CPU Architecture:Any
Tags: federated, remote server

[17 Jan 2007 10:17] Giuseppe Maxia
Description:
The new CREATE/ALTER/DROP SERVER syntax to support Federated tables should be complemented with a command to show which servers are available.
Missing that, one is not sure if the right server is being removed (bug#25670).

Currently, the only way of seeing a server is by querying the mysql.servers table, for which not all users have privileges.
Actually, the current implementation allows a user without privileges to create and remove servers (bug#25671), but not to see which ones are available.

How to repeat:
create a server.
Try to see the list of servers

Suggested fix:
add a SHOW SERVERS command (and eventually a SERVERS or SOURCES table in the INFORMATION_SCHEMA)
[18 Jan 2007 19:59] Peter Gulutzan
Changed severity to "feature request".