View Single Post
  #1  
Old 01-21-2015, 12:20 PM
Bohbo
Hill Giant
 
Join Date: Dec 2012
Posts: 116
Default Read Only Accounts

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

Code:
CREATE USER '<username>'@'ExtIPAddress';
GRANT SELECT ON *.* TO '<username>'@'ExtIPAddress';
Hope someone finds this useful, cheers.

Bohbo
Reply With Quote