/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

-1 vote152 views1 answer
Su: Authentication failure mysql
SQL
0 vote174 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote142 views1 answer
Sql server whoami
SQL
0 vote142 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
4 votes151 views1 answer
Oracle show errors
SQL
1 vote156 views1 answer
Type int in mysql maxlenght
SQL
0 vote199 views1 answer
T-sql delete view if exists
SQL
17 votes162 views5 answers
Order by sql
SQL
0 vote139 views1 answer
Sql trim whitespace
SQL
2 votes145 views1 answer
Sql server case sensitive search
SQL

Share