Create read only mysql database user

run.sh

# Login
$ mysql -u root -p

# Check privileges
$ SHOW GRANTS FOR 'read-only_user_name'@'%';

# Remove the privileges if any
$ REVOKE ALL PRIVILEGES ON database_name.* FROM 'read-only_user_name'@'%';

# Give the user access to the database from any host
$ GRANT SELECT ON database_name.* TO 'read-only_user_name'@'%' IDENTIFIED BY 'password';

# Update privileges
$ FLUSH PRIVILEGES;