This is probably something simple that I am just not seeing, but I
would appreciate your help.
As root, I have created a schema named test, along with several
tables.
I then created a template user named SysAdmin for test using the
following syntax.
GRANT SELECT, INSERT, UPDATE, DELETE
ON TEST
TO SysAdmin IDENTIFIED BY 'password'
WITH GRANT OPTION;
I plan on using SysAdmin as a template for other users. How do I do
this? I would expect to be able to login as SysAdmin and then create
a new user using something like:
GRANT ALL
ON TEST
TO USER1 IDENTIFIED BY ‘user1';
However I continue to get errors saying something like "SysAdmin does
not have access to MySQL". Do I have to do this as root? If so, what
is the syntax to do so?
Thanks.
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
