MariaDB 10.6に指定ユーザーの権限を確認する

2022年1月9日

環境
Windows 10 64bit
MariaDB 10.6.4

指定ユーザーの権限を確認します
書式
SHOW GRANTS FOR ユーザー名;
操作例

MariaDB [testdb]> SHOW GRANTS FOR `arkgame02`@`localhost`;
+------------------------------------------------------------------------------------------------------------------+
| Grants for arkgame02@localhost                                                                                   |
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `arkgame02`@`localhost` IDENTIFIED BY PASSWORD '*AFF33F36F68159E68DBA95F22F0A346DD919E1C1' |
| GRANT ALL PRIVILEGES ON `testdb`.* TO `arkgame02`@`localhost`                                                    |
+------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)