/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 vote236 views1 answer
Install sql server windows 10
SQL
6 votes254 views2 answers
Psql load dump
SQL
3 votes240 views1 answer
Select count from table mysql
SQL
0 vote228 views1 answer
Create new table pl sql
SQL
1 vote230 views1 answer
Oracle index partition
SQL
0 vote246 views1 answer
Mysql listing get a particu particular user firsdt
SQL
1 vote255 views2 answers
Snowflake alter column data type
SQL
1 vote247 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote265 views1 answer
Postgre query date
SQL
0 vote260 views1 answer
DATEDIFF minute postgres
SQL

Share