/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

24 votes330 views5 answers
Sql reset auto increment
SQL
1 vote351 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote359 views4 answers
What is unique key in sql
SQL
3 votes336 views3 answers
Sql current year
SQL
0 vote345 views1 answer
How to query all tables mysql at the same time
SQL
-1 vote353 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote356 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote343 views1 answer
Like and not like together in sql
SQL
0 vote352 views2 answers
Sql query for getting details by id
SQL
0 vote342 views2 answers
Find lowest number in sql
SQL

Share