Connecting to Navicat 8

Post Reply
valadilene
Posts: 9
Joined: Thu Mar 28, 2013 3:42 pm

Connecting to Navicat 8

Post by valadilene » Sun Mar 31, 2013 7:39 pm

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?

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: Connecting to Navicat 8

Post by whasf » Sun Mar 31, 2013 8:13 pm

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.
-- Whasf

valadilene
Posts: 9
Joined: Thu Mar 28, 2013 3:42 pm

Re: Connecting to Navicat 8

Post by valadilene » Sun Mar 31, 2013 8:46 pm

thanks :)

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

bluekirby0
Developer
Posts: 707
Joined: Sun Jul 22, 2012 12:11 am

Re: Connecting to Navicat 8

Post by bluekirby0 » Tue Apr 16, 2013 6:32 am

You need more general mysql help...You are better off looking up a guide or asking for help on a site dedicated to mysql.

Post Reply