Admining MySQL with external programs

[kalleksi]

Hi,

Is there any chance to admin my SiteGround account's MySQL space with external programs? I don't like PHPMyAdmin, so i would like to use external programs such as HeidiSQL.

Regards,
Kalle

[thebizn]

I am also interested in doing this - I tried today using a sql synchronisation program called myManager but apparently I need an http tunnelling link.

On other forums I found this info:

MySQL Host Address: my website - (register your own website IP as an allowed database user in Cpanel/Database area)
Username: my username (normal database/cpanel name)
Password: my password
Port: 2082

It does not work for me!

[Rob Sykes]

I'd like to add my support for this functionality to be added. I prepare a small match-day magazine for my football (soccer) club using the Scribus desktop publishing software and much (75%) of the content - result listings, tables, etc., could be automated by a script connecting to my MySQL database.

[Brandon]

Hello all :)

Prior you are able to connect to your MySQL database from remote you will need to do some basic setup :)

First of all, you should go to www.whatismyip.com. There you can reveal your current IP address.

Then, you should go to your cPanel, choose the MySQL databases link and at the end of the page to add your IP address to the authorized hosts.

After doing this -- you will be able to access your MySQL databases remotely.

[thebizn]

We need the server address.

the mysql program I use asks for the server (a url I presume?) and its port. Can't do anything without that info. If I can connect directly it might correct my phpMyAdmin connection problem.

[Rob Sykes]

We need the server address.

the mysql program I use asks for the server (a url I presume?) and its port.

Try the URL of one of your sites. I've just done this and a connection appears to have been made. However there is no list of database schemata to use. Will play about until or unless we get an update

[thebizn]

I understand that the Allowable hosts address will change each time the modem/router starts and so it needs to be redone each time.

I tried that and I used ns1.siteground171.com as the address but I get this message : (see image).

[Rob Sykes]

I understand that the Allowable hosts address will change each time the modem/router starts and so it needs to be redone each time.

I tried that and I used ns1.siteground171.com as the address but I get this message : (see image).

I logged in using the username and password of the database I set up in cPanel rather than the cPanel user/pass. However, I am no nearer seeing a populated connection so

*waves to SiteGround personnel*

Any further clues?

[thebizn]

IF it is anything complicated it looks like support won't go into it. I can't get a good connection to my databases and can't get any real help. Its hard to * disabled word ** disabled word ** disabled word ** disabled word ** disabled word ** disabled word ** disabled word *te the problem from the other end as it were, but you would think that someone could try and connect using a similar program. I'll look around on more expert forums and post back.

[Rob Sykes]

Whether things have changed behind the scenes or not or whether I was just being a bit dim, I'm not sure, but things have started to work in the way that we want (I haven't looked at this problem for about a month - wait a minute! I've moved and changed internet provider in that month. Hmmm!)

There was a guy - gcaa - on a similar thread to this who suggested the idea and it is now working for me.

I'm logging in from MySQL Query Browser which can be downloaded from the MySQL site - which asks for the following information (slightly anonymised answers in bold)

Server Host: www.'mydomain'.com Port: 3306

Username: 'cPanel Username'

Password: 'cPanel Password'

Default Schema: 'DatabaseName'


The trick is to allow the MySQL server on your host machine to accept commands from your own computer. Now, it's likely that your IP address will change each time you access the internet. Putting the raw IP address each time is a pain so the IP address needs to be resolved to the relevant hostname - there are tools on the web to do this or you can do a traceroute to your Siteground host which will show you your effective hostname. I got (similar to gcaa) something like

range81-93.myisp.com

where the first element changes each time I connect to the internet.

Going to cPanel and then MySQL databases: at the bottom is a box marked Access Hosts. If you add %.myisp.com to the list then (mildly insecurely) all requests from that isp will be accepted.

Hope this helps and kudos to gcaa

[George Y.]

Hi,

Generally, if you do not have a static IP address you can simply add "%" to the allowed hosts. This will allow connections from every IP address which should resolve your case.

Some of you may find it as a security issue, thus, you can add a a range in a different way:

192.0.0.%

the first 3 digits are an example -- you should change them considering your ISP IP addresses.

Kind regards.