MariaDB 10.6.4で権限の確認と付与のサンプル
環境
MariaDB [testdb]> select version(); +----------------+ | version() | +----------------+ | 10.6.4-MariaDB | +----------------+ 1 row in set (0.001 sec)
操作方法
1.登録されているホストとユーザー名を確認します
MariaDB [(none)]> select user,host from mysql.user; +-------------+-----------------+ | User | Host | +-------------+-----------------+ | root | % | | test05 | %.arkgame.com | | root | 127.0.0.1 | | test04 | 172.17.1.200 | | test06 | 172.17.12.% | | root | ::1 | | test01 | arkgame.com |
2.特定のユーザーの権限を確認します
MariaDB [(none)]> show grants for 'test04'@'172.17.1.200'; +------------------------------------------------------------------------------------------------------------------+ | Grants for test04@172.17.1.200 | +------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `test04`@`172.17.1.200` IDENTIFIED BY PASSWORD '*84F9574D0CE7CEDFED996451B6926F824C94B242' | +------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec)
3.権限の付与
書式
GRANT 権限 ON レベル TO ユーザ IDENTIFIED BY PASSWORD '****’
実行例
MariaDB [(none)]> grant select, update on testdb.* to 'root'@'localhost' identified by 'arkgame'; Query OK, 0 rows affected (0.086 sec)