Skip to content

Create new mysql user

sujit22993 edited this page Feb 3, 2021 · 1 revision
  • 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/