MySQL Forums
Forum List  »  MySQL Workbench

How can I open MySQL database to other server/ machine
Posted by: Jia Wei Leow
Date: November 19, 2022 07:06PM

I am new to database and currently working on data scraping project. I am able to export the data automatically into the database (i am using workbench for querying), however I am stuck at connecting to the database using other machine.

Lets just imagine my PC is connected to specific router and will be in operation 24/7, and i want others to be able to access to database created in this machine.


What I have heard from others and I have tried:
1. create a forwarding port 3306 in router (whitelisting)
2. go to firewall defender create an inbound for port 3306
3. get the public IP

After the above 3 steps I attempted to make connection on other machine using public IP, it failed. Can I get some guidance?

Options: ReplyQuote


Subject
Views
Written By
Posted
How can I open MySQL database to other server/ machine
44
November 19, 2022 07:06PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.