Creating a read-only database user account for MySQL

mysql -u root -p

grant select on database_name.* to 'read-only_user_name'@'%' identified by 'password';

flush privileges;