# Viewing User Account Information

__*zz-BGL*__
__*zz-Jeff*__

```
tidb> SELECT user, host, authentication_string FROM ~!@mysql.user@!~;
+------+--------------+-------------------------------------------+
| user | host         | authentication_string                     |
+------+--------------+-------------------------------------------+
| root | %            | *7451D85E369BF796CD15900AF9BFE0D5D920716E |
| jack | 172.31.0.106 | *926E4B88EB93FD344DF0870EE025D6EB153C02DE |
+------+--------------+-------------------------------------------+
2 rows in set (0.00 sec)
```

-------------------------------------------------------------
`TiDB` stores user account in the `mysql.user` system table. Each account is identified by a `username` and `host`. You can set a password for each account. The user's password is encrypted and stored in the `mysql.user` table.