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, 1536🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...