Thread: EOC issue
View Single Post
  #4  
Old 03-20-2015, 04:51 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by warkid View Post
this is what i did


To create your database user you will need to run the query below to create your database user:
This will allow connections only from EOC via the specified user below, you shouldn't need to change the password because you are only allowing from the EOC server


CREATE USER 'eoc_database_user'@'69.168.254.244' IDENTIFIED BY 'eoc_database_password';
GRANT GRANT OPTION ON *.* TO 'eoc_database_user'@'69.168.254.244';
GRANT ALL ON *.* TO 'eoc_database_user'@'69.168.254.244';


i copy and pasted the query?
Change 'eoc_database_user' to 'eoc_db_user' in all occurrences. That will take care of your character limit.
Reply With Quote