...
For the remainder of this page, if you see mysql in the command line, add the proper path to mysql for your particular operating system.
| Info | ||
|---|---|---|
| ||
This will also enable WranglerView to view performance charts when run from the supervisor. |
How to fix the problem when logged into the supervisor
It's necessary to explictly grant the qube_readonly user read-only access from localhost by running the SQL statement on the supervisor machine:
mysql -u root -e "GRANT SELECT ON *.* TO 'qube_readonly'@'localhost';"
Then, restart the QubeGUI, and the "access denied" messages should no longer occur.
Why it occurs
The MySQL default permissions are refusing the qube_readonly user access to the databases. We'll take a quick look at why this occurs, and then how to fix it.
...
The USAGE permission is effectively an empty GRANT statement, which means "no read permission", and overrides the previous permissions grant for qube_readonly from all machines.
How to fix it when logged into the supervisor
It's necessary to explictly grant the qube_readonly user read-only access from localhost by running the SQL statement on the supervisor machine:
mysql -u root -e "GRANT SELECT ON *.* TO 'qube_readonly'@'localhost';"
Then, restart the QubeGUI, and the "access denied" messages should no longer occur.