Bug #10158 Unable to grant privileges on databases with long names

• Submitted: 25 Apr 2005 20:16
• Modified: 9 Feb 2007 8:14
• Reporter: Fábio Gomes
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[25 Apr 2005 20:16] Fábio Gomes

Description:
MySQL allows databases to be created with long names (e.g 18 chars), but won't allow GRANT on those databases.

How to repeat:
Create a database with a long name and try to GRANT privileges on it.
MySQL answers: "The host or user argument to GRANT is too long"

Suggested fix:
The server should either refuse the long name during the database creation, or accept it for GRANT.

[9 Feb 2007 8:14] Sveta Smirnova

Thank you for the report.

This bug is already fixed.