/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 vote269 views1 answer
Autocommit mysql
SQL
0 vote274 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
7 votes304 views2 answers
Postgres concat
SQL
4 votes291 views3 answers
Sqlite show columns
SQL
1 vote323 views3 answers
Epoch to datetime
SQL
1 vote317 views1 answer
Mysql curdate between two dates
SQL
0 vote292 views2 answers
Sql join on wildcard
SQL
13 votes292 views2 answers
Sql join
SQL
24 votes305 views4 answers
Mysql datetime
SQL
3 votes303 views2 answers
Sql paging query
SQL

Share