/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 vote151 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
9 votes131 views3 answers
Show table columns mysql command line
SQL
1 vote141 views1 answer
Isnull sql server
SQL
13 votes130 views2 answers
Check if value is null mysql
SQL
0 vote137 views1 answer
Mysql streaming example
SQL
10 votes163 views4 answers
Inner join in update query mysql
SQL
12 votes157 views1 answer
Run mysql instance in docker
SQL
0 vote127 views1 answer
Install mysql 8 linux
SQL
3 votes134 views1 answer
Convert sqlite table to pandas dataframe
SQL
14 votes139 views3 answers
Alter foreign key
SQL

Share