We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
select host, user from mysql.user;
CREATE USER 'demo_user'@'%' IDENTIFIED BY 'demo-secret-key';
GRANT SELECT ON digitalgreen.* TO 'demo_user'@'%';
FLUSH PRIVILEGES;
ref - https://kodejava.org/how-to-create-a-read-only-mysql-user/