giving a mysql user read only privileges

[Petrus4]

Hi can anyone let now how I can give a mysql user read only privileges to a database?

The priveleges system is confusing to me.

I am using navicat and these are the options:

Select_priv
Insert_priv
Update_priv
Delete_priv
Create_priv
Dropp_priv
Grant_priv
References_priv
Index_priv
Alter_priv
Create_tmp_table_priv
Lock_tables_priv
Create_view_priv
Show_view_priv
Create_routine_priv
Alter_routine_priv
Execute_priv

[internetscooter]

Something that may help, but something you have to be very careful with, is setting up MYSQL Administrator, connecting to the database and then doing stuff that you want though a gui.

The trick is that you need to edit /etc/mysql/my.cnf and "/etc/init.d/mysql restart" with the following parameters.

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
bind-address            = 0.0.0.0

My understanding is this should not be done on an insecure network as it will mean anyone can connect to your database. If you are behind a firewall it should be OK.

[Petrus4]

thanks internet scooter,

what I am looking for is setting the priveleges for a mysql user.

I want these to be read only. I think there must be mysql command to do this for a user.

[internetscooter]

OK here's what I think you might need to do...

1. Connect to the database (in this case wikidb)

mysql --user=root -ppassword wikidb

2. User "GRANT" to create your user and give it restricted access at the same time.

grant select on *.* to 'readonlyuser'@'localhost';

See Adding New User Accounts to MySQL

[Petrus4]

Thanks! Iscooter