How to create user in mySQL for read only access ? CheckedResponsive – MySQL

mysql-tutorials

How to create read only user access in MySQL ?

Create a read-only database user account for mySQL :-

  1. Login into mySQL Window
  2. Syntax :-

GRANT SELECT ON <DATABASE> TO <USERNAME>@’<LOCAL HOST>‘ IDENTIFIED BY ‘<PASSWORD>

3.Example :-

GRANT SELECT ON *.* TO ‘dbadmin’@’%’ IDENTIFIED BY ‘Password@2019’;

 

Related posts

Leave a Comment