/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 vote283 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote226 views1 answer
Mysql max number not returning correct value
SQL
0 vote270 views1 answer
Sql pivot without aggregate
SQL
0 vote214 views1 answer
Mysql update sum same table
SQL
0 vote272 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote257 views1 answer
Get only one row in mysql
SQL
11 votes246 views1 answer
Mysql order by two columns priority
SQL
0 vote229 views1 answer
Sql last 7 days
SQL
1 vote238 views1 answer
Mysql tables max count
SQL
0 vote241 views1 answer
Intellij idea add mysql connector
SQL

Share