/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

39 votes261 views5 answers
Sql drop column
SQL
0 vote163 views1 answer
Oserror mysql_config not found virtualenv
SQL
6 votes168 views2 answers
Foreign key sqlite3 python
SQL
6 votes158 views1 answer
Update left join mysql
SQL
-1 vote161 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote156 views1 answer
Docker export psql sql
SQL
0 vote194 views2 answers
Uninstall postgresql mac
SQL
1 vote166 views3 answers
How to reset id column in sql server
SQL
0 vote150 views1 answer
Mysql Error Code: 1005
SQL
1 vote164 views3 answers
Psql fatal database does not exist
SQL

Share