About Privilieges 1

[Sleidia]

Good Morning.

Will anybody have the kindness to tell me how to
create a user whose privilege will allow him to
SELECT, INSERT, DELETE only, making it impossible for
him to DROP or CREATE?

Thanks to the one who will help.

 

[thegman]

GRANT Select,Insert,Delete ON databasename TO user@ip;

where databasename is the name of your database, user is your username, and ip is where he will be accessing from, i.e. 10.5.34.102. If he can access from anywhere make ip "%".

HTH

Garry

 

[Sleidia]

Thanks Garry!

I was starting to think that mysql users had migrated
toward another forum/planet!

Have a good day.