Используем 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]