SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:51 AM
| ||||
| ||||
 User Administration 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.      |
|
02-28-2008, 06:51 AM
| ||||
| ||||
| Re: User Administration 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 <shreeseva.it@gmail.com> 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 - mdykman@gmail.com - All models are wrong. Some models are useful. |
Linear Mode
