My SQL Read only Permission to User

To create a mysql user with only readonly permission

CREATE USER 'jdk'@'localhost' IDENTIFIED WITH mysql_native_password BY 'jdk1234'
GRANT SELECT ON jdkdb.* TO 'jdk'@'localhost'
Facebook Comments

You may also like