Skip to content

Instantly share code, notes, and snippets.

@goyuninfo

goyuninfo/Grant read-only permission to the MySQL user.sql

Created September 25, 2020 19:03
Show Gist options
  • Save goyuninfo/b516cabcbd584f84db23ff1ad7f71aba to your computer and use it in GitHub Desktop.
Save goyuninfo/b516cabcbd584f84db23ff1ad7f71aba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Grant read-only permission to the MySQL user.sql
-- Grant read-only permission to the MySQL user
-- Copy the following command and paste them into a MySQL shell.
GRANT SELECT, SHOW VIEW ON $database_name.* TO $user@'127.0.0.1' IDENTIFIED BY '$password';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment