How to access MySQL database using static IP over internet?

Question

I have one computer in that MySQL is install and that have a static IP and that is connect to internet. How to access the MySQL database in that pc in another pc over internet?

link 1, link 2

Fahim Parkar
– Fahim Parkar

2012-05-20 12:54:41 +00:00
Commented May 20, 2012 at 12:54 — Fahim Parkar
– Fahim Parkar, Commented May 20, 2012 at 12:54

somnath · Accepted Answer · 2012-05-20 13:04:55Z

2

In the config.inc.php file of PHPMyAdmin set the following line

Original:

$cfg['Servers'][$i]['host']      = 'localhost';

Your version:

$cfg['Servers'][$i]['host']      = 'your_servers_static_public_ip';

Set your_servers_static_public_ip to the public IP address of your server.

If you are using a firewall then you need to remember to open the port 3306 in your firewall to allow remote MySQL requests to reach MySQL server.

answered May 20, 2012 at 13:04

somnath

1,3351 gold badge9 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fahim Parkar · Accepted Answer · 2012-05-20 12:49:47Z

0

Here is a section on connecting to MySQL from the manual.

So, you would use --host and --port.

Also, you would need to configure your firewall to let this traffic pass though, and also possibly the MySQL server to allow connections from external IPs.

edited May 20, 2012 at 12:49

Fahim Parkar

31.8k46 gold badges169 silver badges285 bronze badges

answered May 20, 2012 at 12:42

Jonatan

2,8962 gold badges23 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to access MySQL database using static IP over internet?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related