/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 vote362 views1 answer
Mysql get date diff in months
SQL
0 vote346 views1 answer
Mysql update set sum
SQL
2 votes366 views2 answers
Storing timezones in postgres
SQL
28 votes399 views6 answers
Sql update
SQL
10 votes369 views2 answers
SQL rounding numbers
SQL
-1 vote336 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
2 votes323 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote366 views1 answer
Shortcut run sql pgadmin
SQL
1 vote351 views2 answers
Regex starts with
SQL
0 vote331 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL

Share