/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

1 vote276 views2 answers
Into sql
SQL
1 vote349 views1 answer
Postgresql float 2 decimal places
SQL
0 vote336 views1 answer
How to find sql server installation folder
SQL
2 votes302 views1 answer
Apex execute batch job
SQL
5 votes305 views1 answer
Find table from column name in sql
SQL
0 vote376 views1 answer
Intellij mysql set timezone
SQL
25 votes352 views1 answer
How to update an attribute in MySQL
SQL
0 vote309 views1 answer
How to move a column to different spot mysql
SQL
0 vote293 views6 answers
Unique key in sql
SQL
0 vote305 views1 answer
MySQL get all previous date record
SQL

Share