/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

13 votes177 views4 answers
What is sql
SQL
0 vote187 views1 answer
How to to get time in sql
SQL
3 votes128 views1 answer
V$session not found in oracle
SQL
0 vote157 views1 answer
Complete date is 1 year or not sql server
SQL
3 votes172 views1 answer
Sql cast to integer
SQL
0 vote200 views1 answer
Compress sql file database ubuntu
SQL
1 vote166 views1 answer
Mysql select row max date
SQL
0 vote165 views1 answer
Show create table in postgresql
SQL
0 vote175 views1 answer
Sqlalchemy one column of two has to be not null
SQL
2 votes169 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL

Share