DBA Hub

📋Steps in this guide1/1

List users present in mysql

-- List all users present in mysql

mysql configurationintermediate
by MYSQL
13 views
1

List users present in mysql

-- List all users present in mysql

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
mysql>
select user,host,account_locked,password_expired from mysql.user;
+------------------+-----------+----------------+------------------+
| user             | host      | account_locked | password_expired |
+------------------+-----------+----------------+------------------+
| mysql.infoschema | localhost | Y              | N |
| mysql.session.   | localhost | Y              | N |
| mysql.sys        | localhost | Y              | N |
| root             | localhost | N              | N |
+------------------+-----------+----------------+------------------+
4 rows in set (0.00 sec)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!