/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

13 votes128 views2 answers
Sqlite rename column
SQL
1 vote138 views1 answer
How to print longest name in sql
SQL
0 vote140 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote153 views2 answers
Nested query
SQL
9 votes149 views3 answers
Sequence postgresql
SQL
5 votes133 views3 answers
Mysql remove unique constraint
SQL
6 votes125 views3 answers
How to delete table sqlite
SQL
0 vote150 views1 answer
A network or instance-specific error sql server
SQL
3 votes137 views1 answer
V$session not found in oracle
SQL
0 vote134 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL

Share