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@
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
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
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
Dear Ryan,
have a look at the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management
With the exception of Paul's book on MySQL, you probably won't find a better
explanation of the MySQL privilege system.
> PLEASE I'M GOING
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
