re: Re: MySQL user privilages

2002-12-12 Thread Victoria Reznichenko
On Thursday 12 December 2002 10:03, Ryan McDougall wrote: > Alright I have tried to do the grant like the following: > > GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE > ON "user%".* TO user@% IDENTIFIED BY "password"; > > GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE > ON user%.* TO user@

Re: MySQL user privilages

2002-12-12 Thread Ryan McDougall
Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON "user%".* TO user@% IDENTIFIED BY "password"; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY "password"; With no luck I keep getting an error me

Re: MySQL user privilages

2002-12-08 Thread Paul DuBois
At 9:25 -0800 12/8/02, Ryan McDougall wrote: Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creati

Re: MySQL user privilages

2002-12-08 Thread Ryan McDougall
Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY data

Re: MySQL user privilages

2002-12-08 Thread Stefan Hinz, iConnect \(Berlin\)
leitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Ryan McDougall" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Sunday, Decembe

Re: MySQL user privilages

2002-12-07 Thread Paul DuBois
At 21:39 -0800 12/7/02, Ryan McDougall wrote: Hey everyone, Ok if I issue this command: mysql> grant select,insert,update,delete,create,drop -> on *.* to someusr@"%" identified by 'passwrd'; I already know that this statement creates the user someusr w/ password=passwrd and it can connect from

MySQL user privilages

2002-12-07 Thread Ryan McDougall
Hey everyone, Ok if I issue this command: mysql> grant select,insert,update,delete,create,drop -> on *.* to someusr@"%" identified by 'passwrd'; I already know that this statement creates the user someusr w/ password=passwrd and it can connect from anywhere. What I don't know: Can this user no