/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 vote117 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote121 views1 answer
Psql check if sql script is valid
SQL
0 vote120 views1 answer
Can you write relational algebra into sql queries
SQL
-1 vote116 views1 answer
Insert results of a stored procedure into a temporary table
SQL
1 vote114 views5 answers
Postgresql difference between two dates in days
SQL
0 vote127 views1 answer
How to fetch data from database in sql
SQL
0 vote117 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
8 votes116 views1 answer
Show mysql user table
SQL
-1 vote100 views2 answers
How to display top 50 rows?
SQL
0 vote130 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL

Share