Differences

This shows you the differences between two versions of the page.

--- mysql:standalone [2024/04/06 04:38] – kirtisingh
+++ mysql:standalone [2024/07/15 04:52] (current) – kirtisingh
@@ Line 1: / Line 1: @@
-===Using N99panel VPS as a standalone MySQL server===
+===Accessing MySQL server remotely or using N99panel VPS as a standalone MySQL server===
 **Step 1 :** [[:n99panel:create_mysql_pair|Create a MySQL DB/User Pair]]
@@ Line 19: / Line 19: @@
 {{:mysql:global-access.png?direct&400|}}
-**Step 6 :**
+**Step 6 :** Now go back to Dashboard -> MySQL , and click 'Manage Port 3306'
+{{:mysql:click-port-3306.png?direct&400|}}
+**Step 7 :** Now in the next screen you would see the status of port 3306 as 'closed' . Click 'Open Port' to open port 3306 to the world
+{{:mysql:open-port.png?direct&400|}}
+With these steps MySQL now can be accessed remotely as configured by you.
+Ideally a standalone MySQL VPS should be used with another N99panel VPS instance so that they communicate on the private IP range. To setup a private IP, you would need to contact N99panel support team.
+**Very important :** Please remember any connections to MySQL port 3306 are NOT encrypted. Please use adequate due-diligence and discretion before allowing remote access for MySQL