/SQL/Show list of users in mysql

Show list of 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

See all users mysql

mysql> select host, user, password from mysql.user;

8

Source: alvinalexander.com

Display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

4

SELECT User,Host FROM mysql.user;

SELECT User,Host FROM mysql.user;
DROP USER 'testuser'@'localhost';

1

Similar codes

0 vote129 views2 answers
Imageview setimageresource null
SQL
1 vote130 views1 answer
Oracle sql listagg
SQL
15 votes138 views4 answers
Create table if not exists sql
SQL
2 votes148 views1 answer
Oracle percentage
SQL
2 votes144 views1 answer
Postgresql create schema in specific database
SQL
1 vote142 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote127 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote129 views2 answers
Sql join on comma separated field
SQL
0 vote163 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
1 vote151 views1 answer
Sql group by sum with condition
SQL

Share