ユーザー管理

ユーザー作成

CREATE USER 'user'@'host' IDENTIFIED BY 'password'

SET password FOR 'user'@'host' = 'password'
ALTER USER 'user'@'host' IDENTIFIED BY 'password';

SELECT * FROM mysql.user;
 
（縦に並べて表示）
SELECT * FROM mysql.user \G;

SELECT USER, host FROM mysql.user;

GRANT ALL privileges ON wordpress.* TO 'wpuser'@'192.168.%'

SHOW grants FOR 'user'@'host';
ex) SHOW grants FOR wpuser@localhost;