Page 1 of 1

Connecting to Navicat 8

Posted: Sun Mar 31, 2013 7:39 pm
by valadilene
Hey guys. Sorry to bother you AGAIN.

So I have brought a vps host and currently installing the server onto it. I've come to a snag :(

I'm trying to make a connection with Navicat. But everytime I put the VPS ip address in I get this error "Host 'VALADILENE.shared-servers.com' is not allowed to connect to this MySQL server"

am I doing something wrong?

Re: Connecting to Navicat 8

Posted: Sun Mar 31, 2013 8:13 pm
by whasf
Modify the allowed hosts for the SQL user you're connecting as to come from your IP. I think it defaults to "localhost", so that's why you're seeing that problem.

Re: Connecting to Navicat 8

Posted: Sun Mar 31, 2013 8:46 pm
by valadilene
thanks :)

This'll sound so very dumb.....But how do I go about doing that?

Re: Connecting to Navicat 8

Posted: Tue Apr 16, 2013 6:32 am
by bluekirby0
You need more general mysql help...You are better off looking up a guide or asking for help on a site dedicated to mysql.