Collections:
Other Resources:
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, 349👍, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...