Re: User privileges on a database ... really stuck!

2003-09-16 Thread Egor Egorov
Michael Handiboe <[EMAIL PROTECTED]> wrote: > > I have the MySQL Reference Manual (the brown book), 1st Edition, > and it is a mighty fine book. > > On p256, I follow the examples, but for a user who's supposed > to have access to a single database ('cabs') with the following > privileges: > >

User privileges on a database ... really stuck!

2003-09-15 Thread Michael Handiboe
Hello List Meisters. I have the MySQL Reference Manual (the brown book), 1st Edition, and it is a mighty fine book. On p256, I follow the examples, but for a user who's supposed to have access to a single database ('cabs') with the following privileges: SELECT, REFERENCES, INDEX, ALTER

Re: privileges on a database

2003-08-18 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: > > I am new to mysql admin. I have created a database and set a user name > and passwd for it using > > grant all privileges on MICDB.* to [EMAIL PROTECTED] identified by 'passdw' > with grant option; > > Now the xxx user is able to login in to the database with >

privileges on a database

2003-08-18 Thread geeta
Hi all, I am new to mysql admin. I have created a database and set a user name and passwd for it using grant all privileges on MICDB.* to [EMAIL PROTECTED] identified by 'passdw' with grant option; Now the xxx user is able to login in to the database with the passwd , but he is not having