SysAdmin only has rights to the TEST database. This user will need to be
able to update the mysql database tables and therefore will need access to
the mysql database.
-----Original Message-----
From: Robert Frame
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:15 AM
Subject: Granting privileges to other users
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
