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;

see all users mysql

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

show user mysql

sudo mysql # first run this command to login mysql
select user, host 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;

How to check current user in mySQL

SELECT 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

check current user mysql

SELECT USER();