MySQL Server

MySQL at a glance

Category

Database (database)

Docker image

mysql:8.0

Default version

8.0

Ports

3306/TCP

RAM

1 GB

CPU

1 core

Disk

20 GB

Console

Interactive console (stdin)

Template version

v1.0.0

MySQL server ports

A MySQL server built from this template listens on this port. Open it in your firewall so players and clients can connect.

sudo ufw allow 3306/tcp

MySQL server requirements

These are the template's recommended starting values. Increase it as your data and number of connections grow.

Run MySQL in Docker

The template uses the mysql:8.0 image, default version 8.0. NautilusControl pulls it automatically; to fetch it yourself:

docker pull mysql:8.0

docker-entrypoint.sh mysqld

MySQL settings (environment variables)

You can change these when you create the server or later in its settings.

Files and folders

• /var/lib/mysql — Data
• /etc/mysql/conf.d — Config

How to set up a MySQL server with NautilusControl

1. 1

   Install NautilusControl

   Install the NautilusControl panel and agent on the machine that will run the server. The installation guide covers it, and the 14-day free trial includes 1 node and 5 servers.

2. 2

   Import the MySQL template

   Download this template (a single JSON file) with the button above, then open Templates in NautilusControl and choose Import JSON.

3. 3

   Create the server

   Create a new container and pick MySQL. NautilusControl pulls mysql:8.0, fills in the environment variables listed below, and creates the folders for you.

4. 4

   Open the ports

   Allow port 3306 through your firewall, and forward it on your router if people connect from outside your network.

5. 5

   Start it

   Press Start and follow the startup log in the panel, then use the interactive console (stdin) for commands.

Server files come from www.mysql.com.

Notes

Most popular relational database. Used by WordPress, Laravel, and most PHP applications. Connect with mysql://user:pass@host:3306/dbname

MySQL FAQ