/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 vote256 views1 answer
Postgresql stored procedure update table values
SQL
0 vote236 views1 answer
Turn on foreign keys check mysql
SQL
0 vote241 views1 answer
Mysql subdate
SQL
1 vote254 views2 answers
Mysql limit offset
SQL
3 votes226 views3 answers
How to set up an auto incrementing id db browser
SQL
2 votes226 views2 answers
Install sqlalchemy
SQL
2 votes227 views4 answers
How to find 2nd highest salary in mysql
SQL
6 votes260 views4 answers
Mysql get random row
SQL
1 vote269 views2 answers
Full join
SQL
0 vote233 views1 answer
Sql select min
SQL

Share