/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 vote243 views1 answer
Automated psql csv export script on windows
SQL
3 votes206 views2 answers
Create schema postgres
SQL
0 vote190 views1 answer
Oracle call a function in a insert statement
SQL
0 vote216 views1 answer
How to combine rows in sql server procedure
SQL
0 vote193 views1 answer
Mysql match in serialized data
SQL
0 vote223 views1 answer
Psql generate id in existing database
SQL
12 votes219 views1 answer
Create column sql server
SQL
0 vote196 views1 answer
Postgres set default schema
SQL
8 votes274 views1 answer
Oracle search code in packages
SQL
3 votes201 views1 answer
Oracle apex call duration
SQL

Share