Need to know Mysql database IP address

Community support
#1

Hello Friends,

In my installation, I have installed MySql Server on my machine. I am required to run the cmd:
telnet mysql.mydomain.com 3306
on ubuntu VM. So for this I have purchased domain : mydomain.com. So I need to take hostname: mysql
and need to bind Mysql Database IP address to it. So what is the mysql IP address that I should attach to mysql hostname.
I took localhost and checked my IPV4 address in cmd prompt. I then attached it to
mysql.mydomain.com
But when I ran the cmd:
telnet mysql.mydomain.com 3306
It says:

telnet: Unable to connect to remote host: Connection timed out

So what shall i do to so that my VM can connect to MySql Database?

#2

The bad news is, free hosting does not support remote SQL.
However, the good news are, this is available on the cheapest plans you will ever find - try one of hostinger’s cheapest plans in the market.

#3

Thanks.
But I have MySql locally. Then Why I need to buy hosting for it?
Is it that, below command wont work without buying Hosting?

telnet mysql.mydomain.com 3306

I have already bought domain: mydomain.com

#4

The cmd is:
telnet mysql.mysite.org 3306

#5

Nope, you will need hostinger :slight_smile:

1 Like
#6

Hi @shekhar,

To connect to a database from local PC, host should support remote connections. But, as a free platform, 000webhost does not support remote connections. So, as @ckhawand said you have to upgrade to hostinger if you need to connect with a local database manager. Otherwise, use phpMyAdmin

1 Like