Create user in mySQL database:
How do I know if the current user account has the privilege to create new user?
I get error when I try to create a new user. I need to know if it is my limited privilege or my syntax is incorrect:
CREATE USER 'acuser' IDENTIFIED BY 'mypassword123';
CREATE USER 'acuser'@'localhost' IDENTIFIED BY 'mypassword123';
In both cases I get this error:
ERROR 1064 (HY000): You have an error in your SQL syntax near
I was using the syntax mentioned here:
Also I wanted the new user to have only read-only (SWLWCT) access to one existing table and not to any other.