User Tools

Site Tools


mysql:standalone

Accessing MySQL server remotely or using N99panel VPS as a standalone MySQL server

Step 1 : Create a MySQL DB/User Pair

Step 2 : Click 'MySQL' on the Dashboard

Step 3 : Then Click 'MySQL Pairs'

Step 4 : Now against the appropriate pair, click 'Additional Access Hosts'

Step 5 : Then in the form enter the access host from which access is required. To allow global access, simply enter % sign .

Step 6 : Now go back to Dashboard → MySQL , and click 'Manage Port 3306'

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

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

mysql/standalone.txt · Last modified: 2024/07/15 04:52 by kirtisingh

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki