[RESOLVED] Connect to local MYSQL from online?

[Confessions]

Can you connect to a MYSQL database run locally on your computer (wampserver) from online?

What should you fill in in the host field? Your internet IP?

(I know how to connect to online MYSQL databases, just haven't succeeded with connecting to local ones).

[dagon]

you can connect to nay mysql server if the machine its running on is connected to the net and set up to allow such a connection.

[big_nerd]

You must setup a user in MySQL, if you use % as the host, it will be a wildcard.

I don't recommend this with root, but if you setup users for each DB you NEED to remotely connect to, you can do so with setting up the correct host.

If you don't want to use a wildcard, and I recommend you don't, you will need to know the hostname of where you are connecting FROM.

i.e. your computer = mycomputer.ispname.com
the remote computer (which you intend on conecting TO MySQL) = abc1234remote.remotedomain.com

Then in the host, you would add: abc1234remote.remotedomain.com, unless it uses a dynamic IP (like non-business highspeed).

[Confessions]

mysql_connect('$host', '$username', '$password');

I am trying to access a local MYSQL database on my own computer FROM a paid web hosting. I've created a new user on my local MYSQL allowing outer traffic, but right now I'm uncertain what to put in the $host field.

I tried putting my computer's external IP address (the ones you see when visiting whatsmyip.com) but it didn't work.

[Confessions]

Problem solved now. Turns out I had to open up port 3306 for forwarding on my router cpanel. After that I connected to my MYSQL via my external IP.

Thanks for help guys, keep it up! 🆒