/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 vote355 views1 answer
Create table tablename as select * from tablename
SQL
4 votes321 views1 answer
Sql list users and roles
SQL
0 vote358 views1 answer
How to export only procedures mysql
SQL
0 vote349 views1 answer
Default password for mysql_secure_installation in mac
SQL
11 votes359 views5 answers
How to install sqlite3 python
SQL
19 votes362 views6 answers
Sql create table
SQL
40 votes404 views6 answers
Update table mysql
SQL
1 vote363 views1 answer
Moodle query item quiz
SQL
5 votes353 views1 answer
Oracle ORA-00054 origin
SQL
8 votes380 views2 answers
Phpmyadmin default password
SQL

Share