[SOLVED] [SOLVED] Remote Access to MySQL via Navicat

[Mike]

I want to start learning PHP and MySQL, building forms that will automatically populate tables viewable to those whom I deem appropriate. I think remote access to my MySQL Database User will be very helpful in this process, so if you can give me any insight as to how to do this, I would be very grateful. It asks for host, port, username, password (I figure user+pass= database user and pass that I created).

But the connection isn't working on port 3306.

[Zach]

We disallow external MySQL connections. You can use phpMyAdmin to manage databases.

[Mike]

We disallow external MySQL connections. You can use phpMyAdmin to manage databases.

Ah okay, guess I'll learn queries and such too then haha :)

[Zach]

Queries and such? phpMyAdmin actually has a pretty intuitive interface, but it never hurts to know what is going on behind the scenes and you will need those skills to write web apps.
Sorry that we can't accommodate your need for an exception.

[HiddenKnowledge]

Since when? It works fine for me.. Confused :-/
You just need to setup external mysql in the cpanel..

[Vanilla]

Yep, I was able to connect with MySQL Workbench too.

Just set it up under cPanel, and add your computers IP to the exception list (http://whatismyipaddress.com/).
For some reason, the Workbench wouldn't really accept domain names, but to find the Niftyhost IP, just ping it under CMD-prompt/terminal.

See attached image for info:

  Howto.jpg (Size: 100.92 KB / Downloads: 4)

If it works with MySQL workbench, I don't see why it shouldn't work with Navicat either.