MySQL account privileges

http://dev.mysql.com/doc/refman/5.0/en/show-grants.html
To show privileges, use SHOW GRANTS:
current account:

>SHOW GRANTS;

for another account:

>SHOW GRANTS FOR 'accountname'@'hostname';

For a read-only account, the minimum privilege should be granted is SELECT.
 http://www.symantec.com/business/support/index?page=content&id=HOWTO16962

> grant select on dbname.* to 'readonlyuser'@'%' identified by 'pogo$23';

/******************END**************/