mysql> select Host, User, password_expired, Password from mysql.user;
+-----------+------------------+------------------+-------------------------    ------------------+
| Host      | User             | password_expired | Password                                      |
+-----------+------------------+------------------+-------------------------    ------------------+
| localhost | root             | N                | *AE446F256B93CD6D2BFE2D9DB06206920F3D3846 |
| localhost | work             | N                | *307FC2B1D9DC5939A75036B880097501D3D4AA05 |
| localhost | project          | N                | *9FB0DFB069CEF4E90F11D272FEE775130958E261 |
| localhost | other            | N                | *C5E7D39FE5C6A9A5B59579F693CF91094BB3321E |
+-----------+------------------+------------------+-------------------------------------------+

mysql> create user 'testing'@'localhost' identified by 'password';
    Query OK, 0 rows affected (0.00 sec)
mysql> select Host, User, password_expired, Password from mysql.user;
+-----------+------------------+------------------+-------------------------------------------+
| Host      | User             | password_expired | Password                                      |
+-----------+------------------+------------------+-------------------------------------------+
| localhost | root             | N                | *AE446F256B93CD6D2BFE2D9DB06206920F3D3846 |
| localhost | work             | N                | *307FC2B1D9DC5939A75036B880097501D3D4AA05 |
| localhost | project          | N                | *9FB0DFB069CEF4E90F11D272FEE775130958E261 |
| localhost | other            | N                | *C5E7D39FE5C6A9A5B59579F693CF91094BB3321E |
| localhost | testing          | N                |                                           |
+-----------+------------------+------------------+-------------------------------------------+
    5 rows in set (0.00 sec)

mysql> SHOW GRANTS FOR 'root'@'localhost';
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION        |
+---------------------------------------------------------------------+
    2 rows in set (0.00 sec)