I'm connected to a server's mySql database hosted on google cloud using the user 'root' with a password.
I was under the impression that the root user had all privileges but when I try to get the thread information using
SHOW ENGINE INNODB STATUS, I get an error:
[Error Code: 1227, SQL State: 42000] Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
Does it have something to do with me trying to access the database remotely?
What's the difference between