Create User

CREATE USER 'report_user'@'localhost' IDENTIFIED BY 'secret';

Grant Permissions

GRANT SELECT ON school.* TO 'report_user'@'localhost';