/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 vote272 views1 answer
Mysql check string don't have number
SQL
1 vote262 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote283 views1 answer
How to add mysql to path on termin after installation
SQL
1 vote271 views1 answer
Ubuntu access database from terminal
SQL
8 votes280 views2 answers
Mysql grant all privileges to user from any host
SQL
3 votes292 views2 answers
Mysql update row
SQL
0 vote257 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote273 views1 answer
Sql select duplicates based on two columns
SQL
23 votes280 views2 answers
Query to delete a database in mysql
SQL
5 votes251 views1 answer
Pl sql asynchronous procedure calls
SQL

Share