/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 vote181 views1 answer
Postgres first_value in gropby
SQL
0 vote167 views1 answer
Narural join
SQL
1 vote189 views1 answer
Create table tablename as select * from tablename
SQL
0 vote169 views1 answer
Disableforiegn key check
SQL
10 votes176 views2 answers
Forgot my mysql password mac
SQL
0 vote173 views1 answer
Export partttion and import in oracle
SQL
12 votes216 views4 answers
How to drop all tables in postgresql
SQL
1 vote171 views1 answer
Mysql show data from table
SQL
0 vote180 views1 answer
Sql track modification
SQL
0 vote180 views1 answer
Sql delete dastabase
SQL

Share