/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

0 vote135 views2 answers
How to start postgresql laravel
SQL
1 vote178 views1 answer
Add sequence postgres
SQL
0 vote184 views1 answer
Postgresql concat string with separator
SQL
13 votes140 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
94 votes226 views4 answers
Create database postgres
SQL
0 vote143 views2 answers
Insert into
SQL
7 votes153 views1 answer
Oracle pagination query offset
SQL
7 votes234 views1 answer
Oracle alter sequence restart start with
SQL
0 vote197 views1 answer
Migrations.RunSQL
SQL
1 vote161 views1 answer
Update from select oracle
SQL

Share