adding a Mysql user who has only select and insert privilege

linson_85 · 06-23-2009, 12:25 AM

Hello,

How to add mysql user eg: "linson" who has only select and insert privilege and this user should be able to connect to the database from IP (eg: 192.168.1.16)

Thanks in advance.

Wim Sturkenboom · 06-23-2009, 08:21 PM

not tested

Code:

grant usage on yourdatabase.* to 'linson'@'192.168.1.16' identified by 'somepassword'
grant select, insert on yourdatabase.* to 'linson'@'192.168.1.16'

If you want to limit it to certain tables, replace the asterisk in the second line and repeat that line for each table.
If it's about multiple databases, you can use e.g. *.* but that will imply that the user linson also can access the mysql database.