Working on a Ubuntu-14.04 virtual machine.
Theres a MySQL-server running on there. I noticed that the root user doesnt have full access to the performance_schema database.
That leads me to my first question about it: Is the root user supposed to have access to this? What is the default? Is not having access an indicator that the database configuration is not good?
Trying to debug this by giving the root user the missing privileges didnt want to work eighter;
Access denied for 'root'@'localhost'
Then I noticed that there are 2 users called 'root' in the mysql-usertable:
The one thats marked gray is the one in question. I dont have the password for it eighter. How did that get there? And how do I resolve this issue? How can there even be 2 users with matching user names?
UPDATE: Now at least both root-users have the same, known password.
But I am still getting Access Denied-Errors, with both of them. And when I look at the grants for each users, it is clear that they are two different users. But they both have the GRANT option.
Why am I still getting Access Denied?