This is an old revision of the document!
Overview
To list users, might be very simple task, but it is also essential for every DB, feel free to use the SQL below :)
[root@ag-se-tlcasdb2 log]# isql -v MySQL_APACDR01_APACDR +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> [root@ag-se-tlcasdb2 log]# mysql -uroot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 51 Server version: 10.3.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SELECT user,host FROM mysql.user; +---------+-----------------------------+ | user | host | +---------+-----------------------------+ | golden | % | | newuser | % | | root | 127.0.0.1 | | root | ::1 | | | ag-se-tlcasdb2.net.tain.com | | golden | ag-se-tlcasdb2.net.tain.com | | root | ag-se-tlcasdb2.net.tain.com | | | localhost | | golden | localhost | | root | localhost | +---------+-----------------------------+