Quote:
Originally Posted by warkid
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.