/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 vote354 views1 answer
Find invalid datetime field
SQL
0 vote371 views1 answer
Oracle plsql sleep
SQL
0 vote346 views1 answer
What is the use of index in mysql table
SQL
1 vote394 views1 answer
Nullif postgresql
SQL
7 votes340 views1 answer
Postgres base size
SQL
8 votes330 views1 answer
Oracle find text in functions
SQL
0 vote402 views1 answer
Mysql create index lost connection
SQL
0 vote332 views1 answer
Automate mysql cli query
SQL
0 vote333 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
3 votes488 views1 answer
How to get yesterday date in sql
SQL

Share