How to connect to Database hosted on T-Online

Hello Ladies and Gentlemen

Nice to be here , after reading some posts i hopefully think u can help me out.

Problem u may help me :

Database hosted on T-Online Website
Databasename and Username predefined by ISP
I can connect via Putty and enter console
I cant connect directly with HEIDI to the MySQL Database

ISP predefined settings :

Host: mysql5.service
Database: ABC123XXX
Username: JohnDoe
Password: xxx123abc

If i connect with Putty and use console , commandline is like :

mysql ABC123XXX -h mysql5.service -u JohnDoe -pxxx123abc

working fine !!!

Is there a way to connect via Heidi and Putty ( tunneling ) ?

Putty configured as well and described here in Forum
Portforwarded for localhost

What i didnt know is , how to connect to mysql5.service

Usually settings in HEIDI for host when using Putty: localhost port 3307 ( forwarded to 3306 )
but Hostname should be like localhost.mysql5.service

Any suggestions for Syntax of the hostname?

Thnx for help, or at least for the Try ;)

Greetz Mimulus

I don't understand how many machines are involved and I've never configured a tunnel with PuTTY but I suppose it's something like this:

[MySQL Client @ PC]
⇓
localhost:3307 (or whatever port not already in use)
[SSH Client @ PC]
⇓
mysql5.service:22
[SSH Server @ ISP]
⇓
localhost:3306 [if DB server is in a third machine, enter its name here]
[MySQL Server @ ISP]

As far as I know there isn't a top level domain called "service" so I suppose you changed the actual name for the forum.

May too much lines

mysql5.service is original value my ISP ( T-Online ) gives me . Used for MySQL Server 5.x - mysql4.service for MySQL Server 4.x is also available

Connection settings are hostname : mysql5.service
Username: Whatever
Password : available

I can already connect to it from console with commandline i typed on 1st Thread.

I can connect with PHPMyAdmin Login Site which is preinstalled under this URL : https://workplace.t-online.de/pma/
using my connection settings

PHPMyAdmin shows me following information

Server: mysql5.service via TCP/IP
User: whatever@cfapro03.aul.t-online.de <----- Original Info
May i can use this Info to setup connection - not sure

As u said "service" is no TopLevel Domain , agree , I tried to connect with this . Failed

I think , if i am able to connect with Putty Console the Database i should be able to connect with 3rd party Tool ( Heidi ) too ,using tunnel, but not sure :?
May there r some settings in Database Right Management needed i dont know and i am not allowed to change

Anyways thnx for ur Help at this point ,

First i tried was the Support Hotline from ISP , still no clue what they r supporting , but definetly not their products :)

Hi Mimulus,

Man, you won't be able to connect mysql5.service if you aren't inside the local network where that name is valid.

mysql5.service isn't a valid internet address, it is, probably, the computer's name that hold de mysql server.

phpmyadmin is inside the local network where that name is valid, that's why phpmyadmin can connect.

the same explanation is valid for putty. when you open it, putty asks for a computer address, and you give him the address of your webserver. the server is inside that local network, so when you say "connect", you are saying it for a remote computer inside the local network where the name mysql5.service is valid.

solution
ask for the web address or ip (remote, ok?) that belongs to the computer that holds the server.


all my discussion is about point of view. nothing more.


post if you have doubts.

bye

@ laury

Thnx , thats exactly what i thought.

Just hoped there