Jump to content

Connecting To Mysql Remotely


reelwild
 Share

Recommended Posts

I'm trying to access mySQL database via Navicat to import data. I can;t seem to get anyof the settings correct.

 

It wants:

 

Host Name/IP address

Port

User Name

Password

 

I've used our web address, port 3306, the user name for the database & the password. I've also allowed access via MySQL account maintenance for the host.

 

Any ideas?

 

Thanks,

 

Joanne

Link to comment
Share on other sites

I can connect remotely with no problems to mine.

 

I added % to the hosts in cpanel. This removes all ip-based security.

 

Make sure the username is correct - it has your cpanel username at the front of it

 

Make sure the database name is correct - it has your cpanel username at the front ot it.

 

Make sure your password is correct - it does NOT have your cpanel username at the front of it,

 

For the hostname, make sure to use ****** exactly like that.

 

The port should be 3306.

 

Make sure your firewall allows connections both ways through port 3306.

 

Don't worry about the privledges - leave them at default for full access...

Link to comment
Share on other sites

  • 1 year later...
I'm trying to access mySQL database via Navicat to import data. I can;t seem to get anyof the settings correct.

 

I am trying to figure out remote database management, mostly for backups. I checked out Naicat, and while it seems reasonably priced I have a preference for shareware.

 

Did you try out multiple packages before deciding on Navicat ? If so what features does Navicat have that made you decide to use it ?

 

jayr

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...