===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