/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 vote182 views1 answer
Amount of entries in a table psql
SQL
0 vote218 views1 answer
Sql select without column name
SQL
0 vote148 views1 answer
Sql table to store status
SQL
0 vote171 views1 answer
Procedure excute monthly oracle
SQL
4 votes173 views1 answer
Oracle delete last row
SQL
0 vote198 views1 answer
"Hello User Name"
SQL
62 votes449 views8 answers
Mysql add column
SQL
0 vote196 views1 answer
Mysql insert into select transaction c#
SQL
0 vote176 views1 answer
How to save data in database in mysql node
SQL
0 vote214 views1 answer
Gcloud sql instance list
SQL

Share