/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 vote341 views1 answer
Empty table sqlite
SQL
0 vote372 views1 answer
Mysql 3 months ago
SQL
0 vote322 views1 answer
How many columns can be used for creating index?
SQL
0 vote347 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote353 views2 answers
Regex starts with
SQL
9 votes374 views3 answers
Pyodbc connect to sql server
SQL
0 vote326 views1 answer
Show all mongodb
SQL
0 vote341 views1 answer
Soql user profile
SQL
0 vote372 views1 answer
Sql filter rows with condition
SQL
16 votes374 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL

Share