MySql Read only account

[mphayesuk]

I am using mysql with ISPConfig and phpadmin. I know that you can create a user through the ISPConfig interface, but how can I create a read only account.

Is this something that has to be done outside of ISPConfig and done from a command line.

Can anyone give me an exampke or too as to how this can be done.

Thanks

[falko]

You must do this on the command line.

Take a look here: http://dev.mysql.com/doc/refman/5.0/en/grant.html
If you grant only SELECT privileges to a user, he can read only.