MariaDB [(none)]> SELECT * FROM mysql.user; SELECT DISTINCT * FROM ((SELECT a.user, a.host, a.db FROM mysql.db AS a) UNION (SELECT a.user, a.host, a.db FROM mysql.tables_priv AS a) UNION (SELECT a.user, a.host, a.db FROM mysql.columns_priv AS a) ) AS c; SELECT DISTINCT a.user, a.host FROM mysql.proxies_priv AS a WHERE a.proxied_host <> '' AND a.proxied_user <> ''; SHOW DATABASES; SELECT a.user, a.host, a.role FROM mysql.roles_mapping AS a;
|
+-----------+--------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
|
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | Delete_history_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | is_role | default_role | max_statement_time |
|
+-----------+--------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
|
| localhost | mariadb.sys | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | | N | N | | 0.000000 |
|
| localhost | root | invalid | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | mysql_native_password | invalid | N | N | | 0.000000 |
|
| localhost | mysql | invalid | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | mysql_native_password | invalid | N | N | | 0.000000 |
|
| 127.0.0.1 | cross_engine | *1716578ABE5ABBA5E020CE2EA9C8FDCE11DE7BE3 | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *1716578ABE5ABBA5E020CE2EA9C8FDCE11DE7BE3 | N | N | | 0.000000 |
|
| % | maxscale | *79056EDB66388CF5756F81D804E4BF271AACDB9D | N | N | N | N | N | N | Y | N | Y | N | N | N | N | N | Y | Y | N | N | N | N | Y | N | N | N | N | N | Y | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *79056EDB66388CF5756F81D804E4BF271AACDB9D | N | N | | 0.000000 |
|
| % | repl | *50C610800D1B52DF4C81430612A0A4DF1B5487DE | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Y | N | N | N | N | Y | Y | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *50C610800D1B52DF4C81430612A0A4DF1B5487DE | N | N | | 0.000000 |
|
+-----------+--------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
|
6 rows in set (0.001 sec)
|
|
+-------------+-----------+-------+
|
| user | host | db |
|
+-------------+-----------+-------+
|
| maxscale | % | mysql |
|
| repl | % | mysql |
|
| mariadb.sys | localhost | mysql |
|
+-------------+-----------+-------+
|
3 rows in set (0.001 sec)
|
|
Empty set (0.000 sec)
|
|
+---------------------+
|
| Database |
|
+---------------------+
|
| calpontsys |
|
| columnstore_info |
|
| infinidb_querystats |
|
| information_schema |
|
| mysql |
|
| performance_schema |
|
+---------------------+
|
6 rows in set (0.000 sec)
|
|
Empty set (0.000 sec)
|