Skip to content

AS213941 · Peering-20% on all VPS with code NVH20 · Delivered in 60 seconds

Linux VPSFrom €2.49/monthWindows VPSFrom €3.49/monthFiveM serverFrom €0.99/monthMinecraft serverFrom €1.99/month
VPS & Cloud

Ranges

Linux NVMe VPSRoot access, Debian, Ubuntu, Alma…Windows RDP VPSRemote desktop, licence includedDedicated serversIntel Xeon Gold, exclusive resourcesPterodactyl VPSGame panel preinstalled

Network and hosting

Anti-DDoSWeb hostingColocationIP transitVPN

Professionals

Reseller VPSReseller programme
Solutions

Bots and automation

AI agents VPSA server for your coding assistants and autonomous agentsOllama VPSYour private AI without a GPU, data in FranceTelegram bot VPSPython or Node.js, always reachableDiscord bot VPSMusic, moderation, tickets: no downtimeVinted bot VPSMonitor and Discord alerts 24/7n8n VPSWorkflows with no execution limitVPN VPSAn encrypted tunnel exiting in FranceWeb scraping VPSScheduled data collection, dedicated IP

Trading

Forex VPSYour robots manage positions overnightMetaTrader 4 VPSSeveral MT4 terminals on one machineMetaTrader 5 VPSForex, indices and stocks in MT5NinjaTrader VPSFutures and NinjaScript strategiesProp firm VPSChallenges and funded accounts, terminal always onlineAfrica trading VPSMetaTrader in Paris, from North or West AfricaRDP VPSWindows remote desktop, always onTrading bot VPSOpen-source crypto bots, protected API keys

Broker and prop firm VPS

FTMO VPSDedicated French IP, outside the USFundedNext VPSPrivate VPS for your EAsThe5ers VPSFixed IP, consistent locationIC Markets VPSWithout the 15 lots a month quotaPepperstone VPSMT4, MT5 and cTrader, fixed priceXM VPSNo $5,000 minimum balanceExness VPSSmall accounts welcome, 7 ms to London

Windows desktop

Windows 10 VPSFor software that requires Windows 10Windows 11 VPSA modern Windows desktop, reachable anywhereSEO VPSLarge-site crawls without tying up your PCStreaming VPSAn OBS studio streaming from the data centreWordPress VPSFast websites on NVMe disks
Marketplace

AI

OllamaLocal language models, with no external APIOpen WebUIA chat interface for your Ollama modelsAnythingLLMA private AI assistant for your documentsLangflowVisual editor for agents, RAG flows and AI APIsFlowiseBuild AI agents and chatbots visuallyQdrantVector database for RAG and semantic search

Trading

MetaTrader 5Official MT5 terminal, ready for your EAsMetaTrader 4Official MT4 terminal, ready for your EAsForex VPS pack (MT4 + MT5)MT4 and MT5 together, on a VPS tuned for tradingNinjaTrader 8NinjaTrader 8 with its prerequisitesFreqtradeOpen-source crypto trading bot, in simulation modeInteractive Brokers TWS / IB GatewayTWS or IB Gateway, official stable version

Bots and agents

Claude CodeAnthropic's coding agent, in your terminalCodex CLIOpenAI's command-line coding agentTelegram botYour Telegram bot, with automatic restartDiscord botYour Discord bot, with automatic restartOpenClawOpen-source personal AI assistant, active 24/7Hermes AgentAutonomous open-source AI agent

Deployment and automation

DockerThe container engine and Docker Composen8nYour automations, with no execution limitPortainerManage your Docker containers from your browserCoolifyDeploy your applications from Git, on your own serverUptime KumaMonitor your sites and servers, with alerts

Websites and databases

WordPressThe most widely used CMS, on a fast Nginx stackApache + PHP + MySQLApache, PHP and MariaDB, ready for your sitesMySQL (MariaDB)MySQL-compatible database serverPleskPlesk hosting panel, with your own licenceNextcloudYour own cloud for files, calendar and contacts

Network and security

WireGuardYour encrypted VPN, preinstalled free of chargeVaultwardenA self-hosted password manager

Game servers

FiveMFiveM server with txAdmin and MariaDB, ready to useMinecraftTurnkey Minecraft Java server, plugins and mods includedRustRust server with automatic updates and Oxide or CarbonCounter-Strike 2Dedicated Counter-Strike 2 server, installed for youPalworldDedicated Palworld server, installed for youValheimDedicated Valheim server, installed for you
Gaming

Game servers

FiveM servertxAdmin, ESX, QBCoreMinecraft serverJava, Bedrock, modpacksRust serverOxide, Carbon, wipesNova-Life serverNova-Life: Amboise RP

Protection and tools

FiveM Anti-DDoSFree tools
Resources

Learn

DocumentationBlog

Assistance

ContactSLA commitment
View plans Client area Peering · AS213941

Security

Securing MariaDB on a VPS: local listening, least privilege and backups

By the NVHCloud team · 2026-09-18 · 5 min read

A database exposed to the Internet is one of the first things bots look for: port 3306 is scanned constantly, and databases left open with a weak password get emptied or held to ransom. This guide installs MariaDB and locks it down. The commands also apply to MySQL, give or take a few file names.

1. Install and secure the installation

apt update && apt install -y mariadb-server
mariadb-secure-installation

Answer the questions as follows:

  • Switch to unix_socket authentication: n if the question appears, since this is already the case on Debian and Ubuntu.
  • Change the root password: n. MariaDB's root account authenticates through the system's root account, with no network password: that is safer than a password.
  • Remove anonymous users, Disallow root login remotely, Remove test database, Reload privilege tables: Y each time.

Then connect as the system root user with the simple command mariadb.

2. Listen locally only

On Debian and Ubuntu, MariaDB listens on the local address only by default. Check it, because a past change or another distribution may have altered it:

ss -tlnp | grep -E "3306|mariadbd|mysqld"

You should see 127.0.0.1:3306. If you see 0.0.0.0:3306 or *:3306, fix it in /etc/mysql/mariadb.conf.d/50-server.cnf:

[mysqld]
bind-address = 127.0.0.1
skip-name-resolve
systemctl restart mariadb

skip-name-resolve avoids a DNS lookup on every connection: it is faster, and accounts must then be declared with an IP address rather than a hostname. If your application runs in Docker, see the Docker paragraph below.

⚠️ Even with a firewall, never open port 3306 to the whole Internet. If another machine has to connect, use an SSH tunnel or WireGuard, or failing that a firewall rule limited to one IP address.

3. One user per application

Never use the root account in an application. Create one database and one user per site or game server, with rights on its own database only:

CREATE DATABASE shop CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'shop'@'localhost' IDENTIFIED BY 'GENERATED_PASSWORD';
GRANT ALL PRIVILEGES ON shop.* TO 'shop'@'localhost';
FLUSH PRIVILEGES;

Generate passwords with openssl rand -base64 24. If one application is compromised, the attacker only reaches its own database. For a tool that only reads, such as a dashboard, even limit the rights to SELECT.

Docker: a container does not connect from localhost but from the Docker network address. The simplest approach is to run the database in a container in the same Compose file, without publishing its port. See Docker and Docker Compose.

4. Audit existing accounts

On a server already in service, list the accounts and where they can connect from:

SELECT user, host FROM mysql.user ORDER BY user;

Any account whose host column is % accepts connections from anywhere. If it is not essential, delete it or restrict it:

DROP USER 'old'@'%';
RENAME USER 'app'@'%' TO 'app'@'localhost';

Also check an account's rights with SHOW GRANTS FOR 'app'@'localhost';. An application account must never have ALL PRIVILEGES ON *.*.

5. Remote access without exposing the database

To use a graphical tool such as DBeaver, HeidiSQL or MySQL Workbench from your computer, go through an SSH tunnel: the database stays closed to the Internet.

ssh -N -L 3307:127.0.0.1:3306 alex@VPS_IP

While this command runs, connect your software to 127.0.0.1 on port 3307. Most tools can also create this tunnel themselves, in an "SSH" tab of the connection settings.

6. Tune memory

The setting that matters most is innodb_buffer_pool_size, the memory where MariaDB keeps the most-used data and indexes. The default, 128 MB, is too low as soon as the database grows. On a VPS that also hosts the website or game server, give it about a quarter of the RAM:

[mysqld]
innodb_buffer_pool_size = 1G     # for a 4 GB VPS
max_connections = 100

To estimate the need, compare with the actual size of your data:

SELECT ROUND(SUM(data_length + index_length) / 1024 / 1024) AS size_mb
FROM information_schema.tables WHERE engine = 'InnoDB';

There is no point going beyond that size plus a margin for growth.

7. Back up

Do not copy the files in /var/lib/mysql while the database is running: the copy would be inconsistent. Export instead:

mariadb-dump --all-databases --single-transaction --routines --events | gzip > /var/backups/mariadb.sql.gz

--single-transaction produces a consistent export without blocking applications. Automate the export and send it off the server: see backups with Borg. To restore: gunzip -c mariadb.sql.gz | mariadb.

8. Updates

MariaDB maintenance releases arrive through normal system updates. If you enabled the automatic security updates described in first steps, they install themselves. Before moving to a new major version, take a full export, then run mariadb-upgrade after the update if it did not do so itself.

Frequently asked questions

Do I need to open port 3306 for a website to reach its database?

No, if the website and the database are on the same VPS: the connection goes through the local address or the socket, not the network. Port 3306 should only be opened for another machine, and then only for its IP address or through a VPN.

MariaDB or MySQL?

Both are largely compatible and suit WordPress, FiveM and most applications. MariaDB is the default database on Debian and Ubuntu, which simplifies installation and updates. Choose MySQL if an application explicitly requires a feature specific to MySQL 8.

I lost the MariaDB root password. What should I do?

On Debian and Ubuntu, MariaDB's root account authenticates through the system: log in as root on the server and simply type mariadb. You can then reset the password of any account with ALTER USER.

What value should I give innodb_buffer_pool_size?

On a server dedicated to the database, up to 70 % of memory. On a VPS shared with a website or game server, about a quarter of the RAM, without exceeding the actual data size plus a margin for growth.

Linux NVMe VPS

Root access, Intel Xeon Gold and NVMe, delivered in 60 seconds. From €2.49/month.