Differences

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

--- nodejs:mysql [2024/07/15 00:43] – created kirtisingh
+++ nodejs:mysql [2025/11/05 00:45] (current) – kirtisingh
@@ Line 1: / Line 1: @@
-===Accessing MySQL server on your N99panel VPS===
+===Accessing MySQL server on your N99panel VPS via NodeJS===
-Content to be added
+**Step 1 :** Enable remote access for MySQL server using the documentation at [[:mysql:standalone|MySQL Remote Access]] . You **do not need to open port 3306** unless you require to provide access to the outside world to port 3306 directly.
+**Step 2 :** Refer to steps 4 and 5 of the above mentioned documentation, and add the following value in the 'Additional Access Hosts' field.
+<code>
+.16.%.%
+</code>
+**Step 3 :** In your NodeJS codebase or in the concerned .env file, use the value **172.16.26.1** as the DB Host
+Using the above steps, your NodeJS App should be able to access MySQL server on the N99panel VPS.