/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 vote153 views1 answer
QCompleter con sql
SQL
9 votes182 views4 answers
Postgresql export database
SQL
0 vote176 views1 answer
Sql datediff month
SQL
5 votes160 views1 answer
Sql first day of current year
SQL
0 vote188 views1 answer
Pass array parameter to stored procedure c#
SQL
11 votes179 views2 answers
Safe mode off mysql
SQL
0 vote207 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote181 views1 answer
Vbscript clean up ADODB.Recordset
SQL
4 votes257 views4 answers
Remove duplicate old value in mysql
SQL
0 vote213 views1 answer
Sql select merge multiple values
SQL

Share