Read Only Accounts

[Bohbo]

I wanted to setup read only access to the EOC 2.0 so my tester devs can access specific information but not screw anything up by writing to the DB.

Here is how I did it. Instead of creating the user as Akkadius Guide describes run the commands like this instead

CREATE USER '<username>'@'ExtIPAddress';
GRANT SELECT ON *.* TO '<username>'@'ExtIPAddress';

Hope someone finds this useful, cheers.

Bohbo

[kugbok]

thanks for this!

[jpyou127]

Thank yas!!

Celestial