/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 vote177 views1 answer
Oracle list partitions
SQL
0 vote197 views1 answer
Get initial in sql
SQL
10 votes183 views1 answer
How to import database in mysql by cmd
SQL
3 votes217 views1 answer
Sql several or
SQL
2 votes181 views2 answers
Install sqlalchemy
SQL
0 vote165 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote206 views1 answer
How to subquey to do not load in live database in
SQL
0 vote228 views1 answer
Sql int vs integer
SQL
1 vote185 views1 answer
Spark sql convert string to date
SQL
0 vote173 views1 answer
Insert into using contant values and source table columns with sql
SQL

Share