I was adding a user to my server via MySQL Workbench. Something went awry; the addition failed. Afterwards my root account could no longer access the DB via Workbench. (access denied)
 I was able to connect as root from the command line mysql -uroot -p but root has no privileges.
 This system has been in place and working, until now, for over a year
The log shows:
 Found invalid password for user: 'mysql.infoschema@localhost'; Ignoring user
 Found invalid password for user: 'mysql.session@localhost'; Ignoring user
 Found invalid password for user: 'mysql.sys@localhost'; Ignoring user
I have no user with GRANT privileges.
 How can I correct the invalid Password issue for these system users?
MySQL 8
 Centos 7

rootstackoverflow.com/questions/1709078/…