Skip to content

Instantly share code, notes, and snippets.

@srockstyle

srockstyle/gist:738e529480699fdc73837c5e6fb0a877

Created September 7, 2018 00:09
Show Gist options
  • Save srockstyle/738e529480699fdc73837c5e6fb0a877 to your computer and use it in GitHub Desktop.
Save srockstyle/738e529480699fdc73837c5e6fb0a877 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL8でのユーザ作成
Raw
gistfile1.txt
mysql> CREATE ROLE super_user_role;
Query OK, 0 rows affected (0.11 sec)
mysql> GRANT ALL ON srockstyle.* TO super_user_role;
Query OK, 0 rows affected (0.15 sec)
mysql> CREATE USER 'srockstyle'@'%' IDENTIFIED BY "aaaaaaaaa" DEFAULT ROLE super_user_role;
Query OK, 0 rows affected (0.02 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment