/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

5 votes218 views1 answer
How to check port number for postgresql
SQL
0 vote225 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote267 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
16 votes228 views4 answers
Sort by sql
SQL
9 votes233 views4 answers
Oracle get table column names
SQL
0 vote246 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote267 views3 answers
Postgres trim string
SQL
0 vote242 views1 answer
Bidirectional outer join sql
SQL
5 votes237 views2 answers
Sql server port number
SQL
0 vote223 views1 answer
Update view sql
SQL

Share