/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 vote305 views1 answer
How to open blade file from blade in laravel
SQL
0 vote375 views2 answers
Sql query print strings and int
SQL
0 vote332 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote326 views1 answer
Mysql page segment
SQL
0 vote313 views1 answer
Addition of 2 column value in mysql
SQL
0 vote304 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote318 views1 answer
Search column name sql
SQL
13 votes338 views1 answer
Views in sql
SQL
0 vote313 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
24 votes361 views6 answers
Sql change table name
SQL

Share