/SQL/Display users in mysql

Display 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

Display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

4

Similar codes

1 vote361 views1 answer
Oracle list data files
SQL
0 vote348 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote354 views1 answer
Placements hackerrank solution
SQL
3 votes499 views1 answer
How to get yesterday date in sql
SQL
0 vote351 views3 answers
Sql select statements
SQL
0 vote465 views1 answer
How to show current database in mysql
SQL
0 vote384 views1 answer
Mysql remove bad character from all fields
SQL
-1 vote379 views1 answer
Select first rows postgresql
SQL
5 votes361 views2 answers
Get columns number sql
SQL
0 vote348 views1 answer
Partitioning in oracle-base
SQL

Share