/SQL/List mysql users

List mysql users

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

List mysql users

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

Mysql list users on ubuntu

SELECT User FROM mysql.user;

2

Source: fastwebhost.in

SELECT User,Host FROM mysql.user;

SELECT User,Host FROM mysql.user;
DROP USER 'testuser'@'localhost';

1

Similar codes

0 vote339 views1 answer
Select from another database
SQL
25 votes378 views6 answers
Import mysql database command line
SQL
0 vote372 views2 answers
Sql auto update dupdated_at
SQL
4 votes358 views2 answers
Oracle unlock user
SQL
0 vote341 views1 answer
Run postgresql dump to csv
SQL
-1 vote359 views1 answer
Mysql case when multiple conditions
SQL
0 vote378 views2 answers
Temp Space
SQL
4 votes349 views1 answer
Is there any command to change postgres password
SQL
0 vote344 views1 answer
Mysql shell set time_zone
SQL
4 votes356 views2 answers
Postgres update single column
SQL

Share