mysql - 如何使用MySQL中的命令行获取用户帐户列表？(How to get a list of user accounts using the command line in MySQL?)

Question

I'm using the MySQL command line utility and can navigate through a database.

(我正在使用MySQL命令行实用程序，可以在数据库中导航。)

Now I need to see a list of user accounts.

(现在我需要查看用户帐户列表。)

How can I do this?

(我怎样才能做到这一点？)

I'm using MySQL version 5.4.1 .

(我正在使用MySQL版本5.4.1 。)

  ask by burntsugar translate from so

Answer 1

Use this query:

(使用此查询：)

SELECT User FROM mysql.user;

Which will output a table like this:

(这将输出如下表格：)

+-------+
| User  |
+-------+
| root  |
+-------+
| user2 |
+-------+

As Matthew Scharley points out in the comments on this answer , you can group by the User column if you'd only like to see unique usernames.

(正如Matthew Scharley 在对此答案的评论中指出的那样，如果您只想查看唯一的用户名，则可以按“ User列进行分组。)