/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 vote142 views1 answer
In query in sql
SQL
1 vote118 views1 answer
Tsql update datetime
SQL
0 vote124 views1 answer
Run sql script file and changes db name in this file using c#
SQL
22 votes128 views4 answers
Mysql date_format
SQL
0 vote117 views1 answer
Mysql shell set time_zone
SQL
0 vote115 views1 answer
Mysql workbench view
SQL
0 vote143 views1 answer
Having all mysql
SQL
92 votes199 views6 answers
Substring
SQL
0 vote107 views1 answer
Oracle list dblink
SQL
0 vote119 views3 answers
How to increase size of column in sql
SQL

Share