/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 vote102 views1 answer
IIF
SQL
1 vote105 views1 answer
Pl sql insert into table
SQL
0 vote128 views1 answer
Sql basic commands
SQL
10 votes56 views2 answers
Django mysql
SQL
-1 vote115 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote114 views1 answer
Get a list of tables and the primary key
SQL
3 votes94 views2 answers
Sql end of month
SQL
5 votes63 views1 answer
Mongodb vs
SQL
0 vote106 views2 answers
Create row number in sql
SQL
0 vote143 views1 answer
Kimball data warehouse sql calendar
SQL

Share