---
title: How to enable remote database access on Cyberpanel server
description: "This guide will take you through how to enable remote database connection on Cyberpanel and access the database remotely. #### Step 1: Access your server via SSH. `ssh root@your-server-ip (ssh root@11.22.33.44)` ![](https://truehost.com/support/wp-content/uploads/2024/10/image-467-1024x302.png) #### Step 2 : Open the mariadb config…"
url: "https://truehost.com/support/knowledge-base/how-to-enable-remote-database-access-on-cyberpanel-server/"
updated: "2024-10-23"
category: Cyberpanel
---

# How to enable remote database access on Cyberpanel server

This guide will take you through how to enable remote database connection on Cyberpanel and access the database remotely.

#### Step 1: Access your server via SSH.

`ssh root@your-server-ip (ssh root@11.22.33.44)`

![](https://truehost.com/support/wp-content/uploads/2024/10/image-467-1024x302.png)

#### Step 2 : Open the mariadb config file (50-server.cnf)

Using your text editor type.

Using vim

`vim /etc/mysql/mariadb.conf.d/50-server.cnf`

Using nano

`nano /etc/mysql/mariadb.conf.d/50-server.cnf`

![](https://truehost.com/support/wp-content/uploads/2024/10/image-472.png)

#### Step 3 : Edit the bind address from localhost to all address (from 127.0.0.1 to 0.0.0.0)

Default

![](https://truehost.com/support/wp-content/uploads/2024/10/image-473-1024x211.png)

New Edited

![](https://truehost.com/support/wp-content/uploads/2024/10/image-474-1024x229.png)

Changing the listening address to `0.0.0.0` allows listening for connections from all IP addresses.

If you need only one IP address to access the database server remotely, then put your IP address there instead.

Save your changes and exit.

#### Step 4: Allow PORT **`3306`** through firewall on Cyberpanel dashboard.

Login to cyberpanel ->Security -> Firewall and add port `3306`

Then restart Firewall.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-475-1024x340.png)

That's it

![](https://truehost.com/support/wp-content/uploads/2024/10/image-483-1024x144.png)

Step 5 : Create a test database to use.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-476.png)

Go to List Databases and click on Manage

![](https://truehost.com/support/wp-content/uploads/2024/10/image-477-1024x499.png)

Use the wildcard " `%` " character

![](https://truehost.com/support/wp-content/uploads/2024/10/image-478.png)

Step 6: Access remotely.

Try accessing the database from your application such as **Mysql workbech** or **DBeaver**.

Using Dbeaver.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-480-1024x460.png)

![](https://truehost.com/support/wp-content/uploads/2024/10/image-481.png)

Test Connection'

It should be successful

![](https://truehost.com/support/wp-content/uploads/2024/10/image-484.png)

All Done and connection successful.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-485-1024x378.png)