/SQL/How to show all users in mysql

How to show all users in mysql

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;

9

See all users mysql

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

8

Source: alvinalexander.com

Display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

4

How to show all users in mysql

SELECT User FROM mysql.user;

2

Source: fastwebhost.in

Similar codes

11 votes204 views6 answers
Distinct sql
SQL
0 vote255 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
8 votes242 views4 answers
Convert date to dd/mm/yyyy sql
SQL
1 vote204 views1 answer
Timestamp in sqlite
SQL
2 votes215 views2 answers
How to run postgresql in linux
SQL
7 votes220 views1 answer
Set sequence value oracle
SQL
1 vote264 views1 answer
Postgres set sequence value to max id
SQL
5 votes234 views4 answers
Mysql update column with value from another table
SQL
0 vote215 views1 answer
Sql server roles and users
SQL
1 vote217 views1 answer
Postgresql filter on
SQL

Share