/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

1 vote195 views1 answer
Oracle see column type
SQL
0 vote163 views1 answer
No suitable driver found for sqlite
SQL
0 vote168 views1 answer
Alter boolean column postgresql
SQL
0 vote179 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote169 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote167 views1 answer
Run mssql server terminal
SQL
1 vote163 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
1 vote176 views1 answer
Oracle drop chain step
SQL
0 vote196 views1 answer
Hue hive UploadingTextFiletoHive
SQL
7 votes166 views4 answers
Mysql delete older duplicates
SQL

Share