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:
⇒ Retrieving MySQL Server information in MySQL
⇐ Connect to MySQL Server with User Account in MySQL
2017-11-25, 1539🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...