/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

0 vote145 views2 answers
Mysql get routine parameter list
SQL
0 vote156 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
15 votes293 views2 answers
Sql order by alphabetical
SQL
14 votes164 views1 answer
Excel is not a database
SQL
6 votes149 views2 answers
Mysql interval 1 day
SQL
0 vote168 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
16 votes149 views4 answers
Mysql import from sql file
SQL
0 vote136 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote154 views1 answer
Sql query wordpress export post
SQL
0 vote146 views1 answer
Less than date query sqlachemy
SQL

Share