MariaDB [(none)]> SELECT user, host FROM mysql.user;
+------------------+---------------+
| user             | host          |
+------------------+---------------+
| dummyuser        | %             |
| dummyuser2       | %             |
| root             | %             |
| root             | 127.0.0.1     |
| forge            | 51.99.999.101 |
| root             | 51.99.999.101 |
| root             | ::1           |
| debian-sys-maint | localhost     |
| forge            | localhost     |
| root             | localhost     |
+------------------+---------------+
10 rows in set (0.002 sec)

MariaDB [(none)]> SHOW GRANTS FOR 'dummyuser'@'%';
+----------------------------------------------------------------------------------------------------------+
| Grants for dummyuser@%                                                                                   |
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dummyuser'@'%' IDENTIFIED BY PASSWORD '*6BB4***************************ED2CA2AD9' |
| GRANT SELECT ON `mydb`.`v` TO 'dummyuser'@'%'                                                            |
+----------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)

MariaDB [(none)]> SHOW GRANTS FOR 'dummyuser2'@'%';
+-----------------------------------------------------------------------------------------------------------+
| Grants for dummyuser2@%                                                                                   |
+-----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dummyuser2'@'%' IDENTIFIED BY PASSWORD '*6BB4***************************ED2CA2AD9' |
| GRANT SELECT ON `mydb`.`v` TO 'dummyuser2'@'%'                                                            |
+-----------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)

MariaDB [(none)]> SHOW GRANTS FOR 'forge'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for forge@localhost                                                                                                              |
+-----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'forge'@'localhost' IDENTIFIED BY PASSWORD '*A9***********************************9B5' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [(none)]>