/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

3 votes204 views1 answer
Oracle APEX elapsed time
SQL
0 vote214 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote194 views1 answer
Concatenate columns in table
SQL
0 vote210 views1 answer
Sqlalchemy get schema from database
SQL
0 vote216 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote162 views1 answer
Update row in sqlite python
SQL
7 votes232 views2 answers
How to create index mysql
SQL
0 vote184 views1 answer
Print orcale
SQL
0 vote219 views1 answer
Mysql config address
SQL
2 votes214 views1 answer
Use cases condition in sql query laravel
SQL

Share