/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 vote205 views8 answers
Convert sql query to linq online
SQL
0 vote221 views1 answer
Add column not null with default value postgres
SQL
1 vote223 views1 answer
Declare variables sql
SQL
0 vote275 views1 answer
Generate a random otp in sql server
SQL
0 vote243 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote226 views1 answer
EnvironmentError: mysql_config not found
SQL
2 votes248 views2 answers
Postgres change owner of schema
SQL
0 vote242 views1 answer
Select nth row in mysql
SQL
6 votes245 views2 answers
How to get yesterday date in mysql
SQL
2 votes279 views1 answer
Remove foreign key constraints in postgres
SQL

Share