database

MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB

In order to list all the configured DB users in a MySQL or MariaDB, you must be logged in as an administrator: /home/grokman grokman@li598-26% sudo mysql -u root -p Then you can issue the command to list all the DB users: select user, Super_priv from mysql.user; So, it should go something like this: Other user …

MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB Read More »