/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 vote204 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote197 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote157 views1 answer
Online sql compiler
SQL
0 vote209 views1 answer
How to get nth number in sql
SQL
14 votes199 views1 answer
Sql value of string
SQL
0 vote194 views1 answer
How to query all tables mysql at the same time
SQL
-1 vote193 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote195 views1 answer
Float precision in psql
SQL
0 vote200 views1 answer
How to use select union and loop
SQL
0 vote185 views1 answer
Mysql function variable
SQL

Share