sys | N | N | N | N | Y | | % | root | Y | Y | Y | Y | N | | localhost | ponsuke | Y | Y | Y | Y | N | + -+-+-+-+-+-+-+ 4 rows in set ( 0. user + -+-+-+-+-+-+-+ | host | user | select_priv | create_priv | insert_priv | grant_priv | account_locked | + -+-+-+-+-+-+-+ | localhost | rdsadmin | Y | Y | Y | Y | N | | localhost | mysql. 26 sec ) mysql > select host, user, select_priv, create_priv, insert_priv, grant_priv, account_locked from mysql. * TO 'ponsuke' 'localhost' WITH GRANT OPTION Query OK, 0 rows affected ( 0.
ユーザーを作って mysql > create user 'ponsuke' 'localhost' identified by 'password' - 権限を付与した mysql > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.
