/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

23 votes259 views6 answers
Delete all rows from table sql
SQL
5 votes269 views1 answer
JBDC
SQL
15 votes272 views1 answer
Mysql int range
SQL
2 votes290 views2 answers
Postgres timestamp to datetime
SQL
11 votes282 views3 answers
Sql line numbers
SQL
0 vote257 views1 answer
What is mysql_pconnect
SQL
3 votes251 views3 answers
Stop mysql service ubuntu
SQL
1 vote256 views2 answers
Setval max id postgresql sequence
SQL
0 vote262 views1 answer
How to order result of subquery in select
SQL
0 vote262 views1 answer
Create function syntax sql server
SQL

Share