create user 'ausername'@'%' identified by 'apassword';Grant SELECT, INSERT, UPDATE, DELETE on aDatabase.aTable to 'ausername'@'%'
I expected these commands to execute successfully. But they yield an error:
[Error code:1064 SQL state:42000] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT SELECT, INSERT, UPDATE, DELETE on aDatabase.aTable to 'ausername'@'%'' at line 2
However when I execute this command in mySQL workbench, they execute successfully.
create user 'ausername'@'%' identified by 'apassword';
Grant SELECT, INSERT, UPDATE, DELETE on aDatabase.aTable to 'ausername'@'%'
I expected these commands to execute successfully. But they yield an error:
[Error code:1064 SQL state:42000] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT SELECT, INSERT, UPDATE, DELETE on aDatabase.aTable to 'ausername'@'%'' at line 2
However when I execute this command in mySQL workbench, they execute successfully.