初期状態のMariaDB (5.5.64)ユーザリスト
MariaDB [(none)]> select user, host from mysql.user; +------+-----------+ | user | host | +------+-----------+ | root | 127.0.0.1 | | root | ::1 | | root | localhost | +------+-----------+ 3 rows in set (0.00 sec)
select current_user();
MariaDB [(none)]> select current_user(); +----------------+ | current_user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec)
新規ユーザーの作成
GRANT ALL ON sampledb.* TO alice@localhost IDENTIFIED BY 'PASSWD';
MariaDB [(none)]> show grants for root@localhost; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '(ハッシュ値)' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)
一般ユーザーの権限
MariaDB [(none)]> show grants for (DB一般ユーザー名)@localhost; +--------------------------------------------------------------------------------------------------------------------+ | Grants for (DB一般ユーザー名)@localhost | +--------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO '(DB一般ユーザー名)'@'localhost' IDENTIFIED BY PASSWORD '(ハッシュ値)' | | GRANT ALL PRIVILEGES ON `(対象DB名)`.* TO '(DB一般ユーザー名)'@'localhost' | +--------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)
