Skip to content
Clodo
Intermediate6 minUpdated: 2026-09-13

MySQL Remote Connection Access and Automated Backups

Guide to enabling remote access on MySQL, configuring user grants, and setting up automated mysqldump backups.

Verified against

MySQL
8.0
MariaDB
10.6 / 11.x
Last checked
2026-09-13

Before you start

  • Root access to the database server
  • The fixed (or known) IP of the connecting client
  • A separate location to store the dumps
On This Page
All Guides
Reading progress

To allow multiple game servers, bots, or web applications to share a centralized database, MySQL must accept remote connections. By default, fresh MySQL installs only bind to localhost (127.0.0.1).

Centralized SQL Database & Secure Remote Access Flow

Architecture allowing multiple nodes to connect to a central database securely via SSL and IP whitelisting.

ARCHITECTURE FLOW
1İSTEMCİ
Remote Clients

Minecraft nodes, Discord bots, and web hosts.

2TLS 1.3
SSL/TLS Layer

Credentials and sensitive rows are encrypted in-transit.

3GÜVENLİK DUVARI
UFW & IP Whitelist

Strict packet filter permits designated server IPs only.

4SQL MOTORU
Clodo MariaDB 10.11

Processes transactional queries on PCIe NVMe with ultra-low latency.

5YEDEKLEME
Automated Nightly Snapshot

Every night at 03:00, compressed gzip dumps are archived.

Clodo
clodo.net / panelLIVE

MariaDB & Redis Cluster

System Normal

Clodo Managed Database Dashboard

Manage remote grants in 1-click, launch phpMyAdmin, and download nightly sql dumps.

Database Status
Online (Port 3306)
Connection Pool
18 / 200
Last Auto Snapshot
Bugün 03:00
Storage Engine
Gen4 NVMe SSD
Clodo Panel Automations1-CLICK READY
1-Click Remote GrantHazır
phpMyAdmin Web AccessEntegre
Instant SQL Dump1-Tık İndir
SSL CA CertificateDoğrulandı

1. Configuring Bind Address#

/etc/mysql/mysql.conf.d/mysqld.cnf
# Varsayilan 127.0.0.1 yerine:
bind-address = 0.0.0.0

2. Granting Remote User Privileges#

MySQL Konsolu
CREATE USER 'clodo_user'@'%' IDENTIFIED BY 'GucluSifre123!';
GRANT ALL PRIVILEGES ON veritabanim.* TO 'clodo_user'@'%';
FLUSH PRIVILEGES;

3. Nightly Automated Backups with Crontab#

crontab -e
0 3 * * * mysqldump -u clodo_user -p'GucluSifre123!' veritabanim | gzip > /backups/db-$(date +\%F).sql.gz

4. Database Management Methods Compared#

Method Comparison

How to Implement This?

Clodo Managed Database Solution

Separate database service

On Clodo a database is not a sub-item created by a button; it is a service of its own. You open a MariaDB plan from the Managed Database category, and its credentials appear on the Database card of the service detail page.

Where in Panel? Open a MariaDB plan under Pricing > Managed Database; host, port, user and password appear on the 'Database' card of the service detail page.
Step-by-step Execution:
  1. 1Open the MariaDB plan from the Managed Database category; no OS install or mysqld configuration required.
  2. 2Copy the host, port, username, password and ready-made connection string from the 'Database' card on the service detail page.
  3. 3Put those values into your game server's or application's configuration.
  4. 4Backups are your responsibility: run the mysqldump steps from this guide on a schedule. There are no automatic backups.

Was this guide helpful?

Feedback goes straight to the team that maintains this guide.

Related Guides

Redis Installation, Memory Constraints, and Password Authentication

Configure in-memory Redis key-value store, tune maxmemory eviction policies, and mandate requirepass authentication.

PostgreSQL 16: Setup, Roles, and Remote Connections

Connect your application to a PostgreSQL service, get roles and schema privileges right, and take backups with pg_dump.