/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 vote363 views1 answer
Isnull sql server
SQL
1 vote355 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote311 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote348 views1 answer
Set default value now() date
SQL
0 vote317 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote379 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote344 views1 answer
Clear query cache sql server
SQL
0 vote312 views1 answer
Show all mongodb
SQL
2 votes381 views1 answer
Datefromparts mssql
SQL
0 vote334 views1 answer
Mariadb select limit offset
SQL

Share