How can I get a list of user accounts using the command line in MySQL?

Peter and Jesse are correct, but just make sure you first select the "mysql" database.

```sql
use mysql;
select User from mysql.user;
```

That should do your trick.

To avoid repetitions of users when they connect from a different origin:

select distinct User from mysql.user;

This displays the list of unique users:

SELECT DISTINCT User FROM mysql.user;

$> mysql -u root -p -e 'Select user from mysql.user' > allUsersOnDatabase.txt

Executing this command on a Linux command line prompt will first ask for the password of MySQL root user. On providing the correct password it will print all the database users to the text file.

SELECT User FROM mysql.user;

Use the above query to get the MySQL users.

Log in to MySQL as root and type the following query:

```lang-none
select User from mysql.user;

+------+
| User |
+------+
| amon |
| root |
| root |
+------+
```

To see your users, it would be to use the mysql database.

```
USE mysql;
```

And then make the select.

```
SELECT user,host FROM user;
```

**Another option** is to put the **BD.Table**.

For example :

```
SELECT user,host FROM mysql.user;
```