/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 vote296 views1 answer
Sql remove decimal places
SQL
9 votes263 views2 answers
Default number in sql
SQL
0 vote296 views1 answer
Exectuer myssql .sql
SQL
5 votes287 views3 answers
Mysql extract month from date
SQL
0 vote306 views1 answer
Wp_query raw sql
SQL
2 votes269 views1 answer
Sql select min value from multiple columns
SQL
0 vote296 views1 answer
Oracle query to find schema you are working on
SQL
4 votes282 views4 answers
Sqlite describe table
SQL
0 vote267 views1 answer
Renommer table sql
SQL
0 vote285 views1 answer
Mysql could not fetch tables
SQL

Share