MySQL: проверить права доступа

0 (0)

Используем SHOW GRANTS.

Проверить права текущего пользователя:

[simterm]

MariaDB [(none)]> SHOW GRANTS;
+-------------------------------------------------------------------------------+
| Grants for replicator@%                                                       |
+-------------------------------------------------------------------------------+
| GRANT REPLICATION SLAVE ON *.* TO `replicator`@`%` IDENTIFIED BY PASSWORD '*' |
+-------------------------------------------------------------------------------+

[/simterm]

Другого юзера:

[simterm]

MariaDB [(none)]> SHOW GRANTS FOR 'username'@'%';

[/simterm]