/SQL/Show list of users in mysql

Show list of 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

See all users mysql

mysql> select host, user, password from mysql.user;

8

Source: alvinalexander.com

Display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

4

SELECT User,Host FROM mysql.user;

SELECT User,Host FROM mysql.user;
DROP USER 'testuser'@'localhost';

1

Similar codes

4 votes350 views1 answer
Oracle delete last row
SQL
0 vote375 views1 answer
Declarative base sqlalchemy
SQL
0 vote362 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote362 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote411 views2 answers
Mysql cast to varchar
SQL
2 votes476 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote349 views1 answer
Adding a new table psql
SQL
0 vote375 views1 answer
Import sql inside hide sql
SQL
2 votes374 views1 answer
Can you use a where clause for a child query
SQL
0 vote373 views1 answer
Sql shell psql cannot enter password
SQL

Share