SQL

show list of users in mysql

//To show all data use following query
select * from mysql.user;
// To show user and host use following query
select User,Host from mysql.user;

see all users mysql

mysql> select host, user, password from mysql.user;

mysql list users on ubuntu

SELECT User FROM mysql.user;

list mysql users

// login to mysql as root
mysql -u root -p
// use mysql database
use mysql;
// list users
select user,host from user;

show all users in mysql

mysql> select * from mysql.user;

mysql list users

# List All Unique Usernames
SELECT DISTINCT User FROM mysql.user;
# List All Usernames + Hostnames;
SELECT User,Host FROM mysql.user;

See all Mysql users

mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| admin            | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+

show list of users in mysql

$ mysql -u root -p  //login with root
Enter password: *********
mysql> use mysql;  //use mysql
Database changed.
mysql> SELECT user FROM user; //show userlist