/SQL/How to show all users in mysql

How to show all 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

How to show all users in mysql

SELECT User FROM mysql.user;

2

Source: fastwebhost.in

Similar codes

1 vote334 views1 answer
Oracle apex run 404
SQL
0 vote359 views1 answer
Set column in all row mysql
SQL
0 vote370 views1 answer
Oracle concat datetime
SQL
0 vote328 views1 answer
Mysql procedure between two tables
SQL
0 vote362 views2 answers
Compound operator in sql
SQL
0 vote327 views1 answer
Select from another database
SQL
0 vote358 views1 answer
Postgresql port 5432 not open
SQL
4 votes324 views2 answers
Error loading MySQLdb module.
SQL
0 vote352 views1 answer
Mysql match in serialized data
SQL
0 vote343 views2 answers
Athena drop partition
SQL

Share