/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 vote197 views1 answer
Mysql milliseconds
SQL
16 votes196 views3 answers
Tsql rename column name
SQL
1 vote182 views3 answers
Grant syntax in sql
SQL
0 vote195 views1 answer
Mysql update even / odd rows
SQL
0 vote219 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote199 views1 answer
Tsql get beginning of year
SQL
0 vote228 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
-1 vote192 views1 answer
Auto increment psql not primary key
SQL
0 vote231 views10 answers
Sql statement checker corrector
SQL
0 vote198 views1 answer
Mysql command line ubuntu
SQL

Share