Differences

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

--- mysql:standalone [2024/04/06 04:21] – created 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]]
+**Step 2 :** Click 'MySQL' on the Dashboard
+{{:n99panel:dashboard-mysql.png?direct&400|}}
+**Step 3 :** Then Click 'MySQL Pairs'
+{{:mysql:click-pairs.png?direct&400|}}
+**Step 4 :** Now against the appropriate pair, click 'Additional Access Hosts'
+{{:mysql:additional-access-hosts.png?direct&400|}}
+**Step 5 :** Then in the form enter the access host from which access is required. To allow global access, simply enter % sign .
+{{:mysql:global-access.png?direct&400|}}
+**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