/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

0 vote210 views1 answer
Sql order by except one row
SQL
0 vote180 views1 answer
Html css mobile menu arrow dropdown
SQL
2 votes188 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote201 views2 answers
Mysql two column combination unique
SQL
-1 vote193 views1 answer
Count occurrences sql
SQL
0 vote199 views1 answer
MySQL import data from large CSV file
SQL
0 vote182 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote177 views1 answer
Sql auto timestamp
SQL
0 vote186 views1 answer
Merge clause with inner join
SQL
0 vote171 views1 answer
Mysql find non alphanumeric characters
SQL

Share