Sql error

[sparky81]

Ok im trying to install a remote server and i have setup tcadmin on my remote server and run the config when i get to the database part and click next i get a error (Host 'xx.xxx.xxx.xxx' is not allowed to connect to this MySQL server) plz can anyone help me as i need this server up and running asap. thanks for any help you can give me

[marcelokruk]

Did you allowed remote connections on the master?

[sparky81]

yes sir i did

[Raizio]

Is the user you made on the sql server host limited?

Is it localhost only or 1 ip only or did you put it to the allow all IP the % symbol(last one not advisable)

[sparky81]

i have fixed it now , it was coz i was trying to use the root user to connect to the database . i made a new user and and changed it all in the master server then ran the config again and all is well and working fine. thanks for the fast replies