I just downloaded and installed the latest MySQL version (5.6) on Windows 8 64bit. Defaults were used during install and it all ran smoothly.
Using MySQL Workbench I created a schema with one simple table and also created a new user. On the schema privileges tab I add a new entry for the user, press the Select "All" button to select the privileges and hit Save Changes. As soon as I do this I get he following error:
Any ideas why this is happening? I am very new to DB's so if you have any alternative methods I can try please explain in simple (step by step) terms.
Thanks
When you open an command-line mysql session and choose the database you can give the command
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,EXECUTE,EVENT,TRIGGER ON dev_runeslinger.* TO 'dev_runeslinger'@'localhost';
So it is a case of mis-interpretation/parsing of the _ since it is escaped.
It appears to be bug #68175 in MySQL Workbench:
Database names containing an underscore showing up escaped/ cause SQL Error
It was reported last month and it's still open so you can either downgrade to a version older than 5.2.46 or wait to see whether it's fixed.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With