How were you manipulating the permissions? I find that the stock query works fine:
GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'%' ; GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'localhost'; although you may want to play around with allowable networks to connect from. More typically, I just do GRANT ALL on mydb.* to mydb@'%' ; does the job nicely. - michael dykman On 7/19/07, C K <[EMAIL PROTECTED]> wrote:
Today I tried to set few user rights for a user. What I need is- There a database called 'mydb' Two users for Mysql 5 on Win 2003 server. One is root and second is 'systemuser'. 'systemuser' do not have right for anything on Mysql, information_schema, but should have only SELECT, INSERT, UPDATE and DELETE rights for 'mydb'. I tried it for a long, but didn't. I have to give SELECT as global privilege. Also I have to set INSERT, UPDATE and DELETE as global privilege. But due to this 'systemuser' can change data in 'mysql' database and I do not want this. If remove any of above from global privilege and set these to only 'mydb' it doesn't work. 'systemuser' will be used to connect to mysql as a default username for many software users. I need to give only SELECT, INSERT, UPDATE and DELETE rights for only 'mydb' while connecting from any location. What can I do? Please help. Thanks, CPK -- Keep your Environment clean and green.
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
