Description:
In MySQL 5.7.7-RC the password column is missing in the mysql.user table (after installation and probably also after mysql_upgrade).

This is a serious backward compatibility break which will possibly make several tools NOT work any more.

How to repeat:
esc mysql.user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field                  | Type                              | Null | Key | Default               | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host                   | char(60)                          | NO   | PRI |                       |       |
| User                   | char(16)                          | NO   | PRI |                       |       |
| Select_priv            | enum('N','Y')                     | NO   |     | N                     |       |

Suggested fix:
set the password column to char(0) for example or just empty it or ignore it for the future to NOT break backward compatibility!

I can see it `authentication_scting` column.

mysql57> SELECT user, host, authentication_string FROM mysql.user WHERE user= 'test';
+------+-----------+-------------------------------------------+
| user | host      | authentication_string                     |
+------+-----------+-------------------------------------------+
| test | localhost | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+------+-----------+-------------------------------------------+
1 row in set (0.00 sec)

This change is introduced by 5.7.6.
http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html

Hello Oli Sennhauser,

Thank you for the report.
Please note that the Password column was removed in MySQL 5.7.6 and now all credentials are stored in the authentication_string column.
This is documented in "https://dev.mysql.com/doc/refman/5.7/en/grant-table-structure.html"

Also, this was explained in the Changes in MySQL 5.7.6 section of manual in - http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html

Also, in upgrade section http://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

Thanks,
Umesh

Hi Umesh,

I know. So you want to tell me, that Oracle/MySQL does NOT care about backwards compatibility? Is that what I have to learn from it?

Regards,
Oli