Access MySQL from 3rd Party Tool

A

acumensofttech

New member
Joined
Feb 1, 2008
Messages
1
Please advice me how can I access the MySql database useing 3rd party tool like Navicat. Currently I am using CPanel, there I can set the IP as "%.%.%.%", by this the database can be access from anywhere. How can I set such thing here?

Looking forward to hear from you soon.

Thanks
 
Last edited:
Theoretically it would work however when the mysql users are installed it only adds permissions for localhost connections. You would have to setup your user permissions in mysql to connect from any location or a selected hostname or ip address.

Maybe directadmin will include a feature to allow remote connections later?
 
At the User Level, click on MySQL Management. Then, select the database you want to give remote access to. Use the Access Hosts option to add the IP address for the hosts you want to have access to the database. Hope this helps.
 
jlandes said:
At the User Level, click on MySQL Management. Then, select the database you want to give remote access to. Use the Access Hosts option to add the IP address for the hosts you want to have access to the database. Hope this helps.
Click to expand...

Would be better if you could do it per user.
 
If you use navicat you can use the tunnel option to access mysql vi localhost.
http or ssh
 
jlandes said:
At the User Level, click on MySQL Management. Then, select the database you want to give remote access to. Use the Access Hosts option to add the IP address for the hosts you want to have access to the database. Hope this helps.
Click to expand...

You still should open up port 3306 in your firewall before this works. But I wouldn't recommand this, rather open port 3306 with an IP access-list, just to be safe.

I know it's a bit more work, but it's a good thing with security in mind.

Regards, Jeroen.
 
Last edited:
no that is not true, port 3306 does (must) not be open if you
use the php or ssh tunnel option.
 
Can you be more specific? I'm not sure what you mean by: "port 3306 does (must) not be open if you use the php or ssh tunnel option"

What PHP or SSH tunnel option?

Don't think SSH is an option, since (our) users don't have SSH access to our servers.

Regards, Jeroen.
 
Last edited:
Navicat comes with a php file named ntunnel_mysql.php

rename it to some unlogical name (you don't have to do this) and
upload it to a place somewhere in your public_html.

You will find this php script in the program files dir on your pc (if you use windows as a client)

Then in Navicat when creating a new connection select the tab "http" and
at use authentication: fill in the field "tunnel url" the username and password
as you would eg. in phpmyadmin

In the "general" tab: hostname is localhost, and fill in the same username and
password as you did at the http tab.

And port 3306 on your firewall does not have to be open. !! because
navicat uses port 80 if you use the http tunnel.

I hope this explanation is a bit usefull.
 
MySQL Administrator 1.2.12

I would like to use MySQL Admin 1.2.12 as third party software to admin my databases. I have added my IP address to the Access Hosts, but it still does not allow access. Does anyone have any other suggestions?
 
You must log in or register to reply here.
Back
Top