/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

2 votes303 views1 answer
Pandas to sql index
SQL
0 vote282 views1 answer
Mysql workbench search all tables
SQL
0 vote289 views1 answer
Soql more than today
SQL
0 vote314 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote309 views1 answer
Mysql not defined
SQL
1 vote297 views1 answer
Load sql into mamp
SQL
0 vote291 views1 answer
Replace null value within column mysql
SQL
18 votes279 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
1 vote271 views1 answer
Mysql get last insert id
SQL
7 votes301 views1 answer
Safe update mysql
SQL

Share