| Bug #69909 | Unable to grant privileges if schema name contains underscore ('_') | ||
|---|---|---|---|
| Submitted: | 2 Aug 2013 15:00 | Modified: | 2 Aug 2013 15:32 |
| Reporter: | Andrei Frolov | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S2 (Serious) |
| Version: | 5.2.47 CE | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | grant privilege underscore | ||
[2 Aug 2013 15:32]
MySQL Verification Team
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=68175 .
Description: Unable to grant privileges if schema name contains underscore ('_') How to repeat: 1. create schema with underscore (ex: 'test_db') 2. In MySql WB goto 'Schema privileges' tab in Server administration | 'Users and Privileges' 3. Select user and press 'Add Entry..' button 4. Click 'Selected schema' radio button, select schema created in step 1 (will be displayed like 'test\_db'), press 'OK' button 5. Choose for ex. 'SELECT' in 'Object Rights' group box, press 'Save changes' button Result: Error: Error executing 'GRANT SELECT ON ...'