/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

0 vote276 views1 answer
Sql query tags
SQL
-1 vote277 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote252 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote283 views1 answer
Query builder doctrien return sql
SQL
0 vote264 views1 answer
Java spring boot connect to sql server
SQL
0 vote258 views1 answer
How to connect postgresql database with java
SQL
3 votes259 views1 answer
Ms sql skip take
SQL
0 vote296 views1 answer
Why do we need data structure in sql
SQL
5 votes282 views1 answer
Oracle nls session
SQL
20 votes244 views5 answers
Mysql reset auto increment to 1
SQL

Share