/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 vote185 views1 answer
Mysql trim characters
SQL
22 votes232 views1 answer
Mysql workbench
SQL
0 vote226 views1 answer
Display all node label neo4j
SQL
0 vote206 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote240 views1 answer
SQL joins in python
SQL
-1 vote185 views1 answer
Condition in orderby mysql
SQL
2 votes229 views1 answer
Sqlite3 show columns name
SQL
2 votes231 views2 answers
Sql query to copy data from one column to another
SQL
0 vote224 views1 answer
Create a plsql object
SQL
49 votes289 views6 answers
Mysql add column to table
SQL

Share