/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 vote137 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote142 views1 answer
Oracle NLS_CHARACTERSET
SQL
5 votes144 views3 answers
Mysql update field from one table to another
SQL
2 votes144 views1 answer
No data found oracle
SQL
0 vote141 views1 answer
Apex for oracle 11g
SQL
0 vote124 views1 answer
Prepared statement mysql java delete selected rows
SQL
-1 vote150 views2 answers
Create temporary table sql
SQL
0 vote142 views1 answer
SQL Server modify_timestamp trigger
SQL
3 votes186 views2 answers
How to View column names of a table in SQL
SQL
0 vote136 views1 answer
RowDataPacket
SQL

Share