MySQL – Add Read-Only User


CREATE USER ‘tester’@’%’ IDENTIFIED BY ‘password’;

GRANT SELECT ON database.* TO ‘tester’@’%’;

 

Advertisements