WEBVTT

00:00:00.180 --> 00:00:05.857
Server tools: create and manage MariaDB
databases on any of your servers. The console

00:00:05.857 --> 00:00:08.997
and scheduled tasks are also reached from here.

00:00:09.347 --> 00:00:11.330
You need a running server.

00:00:11.680 --> 00:00:19.747
Choose a server. If it says "database inactive",
click "Enable database". It takes 1–2 minutes.

00:00:20.097 --> 00:00:26.504
Under "New database" enter a database name
(lowercase, digits and _, starting with a

00:00:26.504 --> 00:00:31.080
letter, e.g. app_production) and a username
(e.g. app_user).

00:00:31.430 --> 00:00:36.997
Click "Create" and copy the access details. The
password is shown only once.

00:00:37.347 --> 00:00:44.054
In your application use host localhost with
these details, as shown under "Connecting from

00:00:44.054 --> 00:00:45.247
an application".

00:00:45.597 --> 00:00:51.298
The list shows each database's size and users.
"Reset password" gives a new password without

00:00:51.298 --> 00:00:52.413
touching the data.

00:00:52.763 --> 00:00:56.497
"Delete" removes a database permanently.

00:00:56.847 --> 00:01:02.980
The database only accepts connections from the
server itself, for security. To reach it from

00:01:02.980 --> 00:01:06.247
your computer (e.g. TablePlus) use an SSH
tunnel.