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
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'