/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 vote248 views1 answer
Add column not null with default value postgres
SQL
4 votes298 views1 answer
Ms sql truncate table vs delete
SQL
0 vote241 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
-3 votes275 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
3 votes294 views2 answers
Truncate table
SQL
0 vote264 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
6 votes248 views2 answers
WHERE value IS sql
SQL
0 vote262 views1 answer
Set a value by excuting stored procedure
SQL
0 vote268 views4 answers
Stored procedure sql
SQL
7 votes261 views3 answers
Foreign key oracle
SQL

Share