目次 |
---|
・ユーザの作成 |
GRANT ON *.* TO ユーザ名 IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO sasuke IDENTIFIED BY 'aaa' WITH GRANT OPTION; Query OK, 0 rows affected (0.03 sec)
mysql> GRANT INSERT,SELECT ON *.* TO sasuke IDENTIFIED BY 'pass'; Query OK, 0 rows affected (0.00 sec)