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
root
stackoverflow.com/questions/1709078/…