/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

0 vote183 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote174 views1 answer
Original Query
SQL
0 vote180 views3 answers
Run sql command line
SQL
1 vote172 views1 answer
Oracle user last connection date
SQL
0 vote181 views1 answer
Dump db only triggers mysql
SQL
23 votes164 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes171 views1 answer
How to find names includes in sql
SQL
0 vote168 views1 answer
Update table sql multiple set
SQL
1 vote182 views1 answer
Age postgres
SQL
0 vote169 views1 answer
Sql track modification
SQL

Share