/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 vote185 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote181 views1 answer
Create synonym for dblink in oracle
SQL
0 vote189 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote174 views1 answer
Alter boolean column postgresql
SQL
0 vote241 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes196 views1 answer
Sql server check for value in multiple columns
SQL
0 vote188 views1 answer
Mysql add root password
SQL
6 votes177 views1 answer
Phpmyadmin reset root password
SQL
0 vote338 views2 answers
Create fulltext index mysql
SQL
4 votes269 views4 answers
Remove duplicate old value in mysql
SQL

Share