/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 vote149 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote130 views1 answer
Mysql search multiple tables
SQL
9 votes154 views3 answers
Where clause sql
SQL
1 vote138 views2 answers
Oracle list partitioned tables
SQL
1 vote168 views1 answer
Mysql default port
SQL
0 vote126 views1 answer
Nth max in my sql
SQL
0 vote137 views1 answer
Sql check if column exists
SQL
1 vote144 views5 answers
What is in operator in sql
SQL
0 vote128 views1 answer
Create bdd mysql
SQL
0 vote102 views1 answer
Postgresql add leading zeros
SQL

Share