SQL

mysql show users

select * from mysql.user;
#or for less data
select user, host from mysql.user;

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;

mysql users and privileges list

SELECT * FROM mysql.user;

SELECT * FROM information_schema.user_privileges;
SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user;
SHOW GRANTS FOR 'my_user'@'localhost';

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;

display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.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