/SQL/Display users in mysql

Display 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

Display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

4

Similar codes

0 vote397 views3 answers
How to find all role in mysql
SQL
12 votes322 views1 answer
How to change the value of a table in sql
SQL
0 vote373 views1 answer
How to find sql server installation folder
SQL
3 votes352 views4 answers
Order by desc postgres
SQL
0 vote411 views1 answer
Split first name and last name in sql
SQL
0 vote339 views1 answer
Insensitive case match sqlalchemy
SQL
1 vote363 views1 answer
How to select random rows from a table
SQL
0 vote374 views1 answer
Manage Database in MySQL
SQL
0 vote370 views1 answer
Pgadmin check database
SQL
3 votes320 views1 answer
Oracle limit user tablespace
SQL

Share