Skip to content

Instantly share code, notes, and snippets.

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