Readonly reporting user for mysql
We would like to be able to do external reporting using queries directly to the mysql database. I've seen other posts here suggesting as much as granting access to root from additional hosts. But, I would rather setup a new user with limited privileges:
mysql> grant select on servicedesk.* to 'reports'@'remotemachine' identified by 'password';
mysql> flush privileges;
While I'm sure this would work, I don't know if this would affect our ability to receive support, etc.
mysql> grant select on servicedesk.* to 'reports'@'remotemachine' identified by 'password';
mysql> flush privileges;
While I'm sure this would work, I don't know if this would affect our ability to receive support, etc.