Collections:
Accessing MySQL Server through Firewalls in MySQL
How To Access MySQL Servers through Firewalls in MySQL?
✍: FYIcenter.com
If your MySQL server is provided by an Internet service company, connecting
to the server from your local machine will not be so easy, because there are
firewalls between your local machine and your MySQL server as shown below:
As you can see, the first firewall could be the one on your local network, if you are using a local computer in an office environment. The second firewall will be the one on your MySQL server provider's network. Usually, firewalls will not allow any network traffic with port number 3306. So there is no way you can run your PHP scripts on your local machine to connect directly to your MySQL server located on your service provider's network.
You have several choices to solve this:
2017-11-25, 716👍, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...