Bug #84349 Error 1054 (42S22) during CREATE USER
Submitted: 27 Dec 2016 20:19 Modified: 27 Dec 2016 22:06
Reporter: Will Barbee Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Windows Severity:S3 (Non-critical)
Version:5.7 OS:Windows
Assigned to: CPU Architecture:Any
Tags: Error 1054 Unknown column 'plugin' 'mysql.user'

[27 Dec 2016 20:19] Will Barbee
Description:
Just deleted old MySQL and installed MySQL 5.7 on Windows 10 PC.
Used the MySQL Windows Installer.
Reloaded previous databases from MYSQLDUMP using MySQL and all OK.
MySQL can do selects and all works OK.

Now trying to set up for Java programs with users to access.
Trying to use commands to define the users per the online ref manual for 5.7:
CREATE USER 'will'@'localhost' IDENTIFIED BY 'will';
GRANT ALL ON *.* TO 'will'@;localhost;

The CREATE USER command returns the message:
ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'
I checked the forums and found no similar problems.

Without users, my programs do not work.
What steps do I take to fix this impasse?
Thanks.
WillB

How to repeat:
Install 5.7 on Win10.
Start mysql and try to create a new user.

Suggested fix:
Unknown
[27 Dec 2016 22:02] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

https://dev.mysql.com/doc/refman/5.7/en/upgrading.html

Thank you for your interest in MySQL.
[27 Dec 2016 22:06] Will Barbee
Thanks, Miguel.

I completely overlooked the mysql_upgrade topic.