/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 vote128 views1 answer
Sql quary stuf
SQL
14 votes107 views2 answers
Oracle limit rows
SQL
0 vote129 views2 answers
Plpgsql
SQL
0 vote101 views1 answer
Postgres week number
SQL
0 vote102 views1 answer
Delete double on SQL with multiple primary keys
SQL
103 votes285 views2 answers
Sql server LIKE '%%'
SQL
0 vote91 views1 answer
Login phpmyadmin without password
SQL
3 votes109 views1 answer
Oracle user quota on tablespace
SQL
11 votes107 views2 answers
Having in sql
SQL
2 votes112 views1 answer
SQL column name Postgre
SQL

Share