EOC issue

[warkid]

im tring to use EOC port is open ... remote access enabled and a user (other than root)

but when i try to source in the details to allow EOC access i get

[SQL]CREATE USER 'eoc_database_user'@'69.168.254.244' IDENTIFIED BY 'eoc_database_password';
[Err] 1470 - String 'eoc_database_user' is too long for user name (should be no longer than 16)

any ideas please

[Akkadius]

Originally Posted by warkid

im tring to use EOC port is open ... remote access enabled and a user (other than root)

but when i try to source in the details to allow EOC access i get

[SQL]CREATE USER 'eoc_database_user'@'69.168.254.244' IDENTIFIED BY 'eoc_database_password';
[Err] 1470 - String 'eoc_database_user' is too long for user name (should be no longer than 16)

any ideas please

Use something less than 16 characters?

[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?

[Akkadius]

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.

[warkid]

i got it thank you for the program .. will help alot