I'm trying to create a MySQL user/password. And every time I create the user - mysql does not honor my password. It's just blank.
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 |
+-----------+------------------+------------------+-------------------------------------------+
Then when I create a new user, it tells me that all was successful.
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)
As you can see, there is no password. I've tried dropping, flushing privileges, and re-adding.
Here are the grant permissions for root.
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)
This is pretty frustrating, and any help would be greatly appreciated.