MariaDB

From wiki
Revision as of 16:12, 31 December 2015 by Vincent (talk | contribs) (Created page with "{{Debian}}MariaDB is a drop-in replacement for the well-known MySQL database. == Installation == <syntaxhighlight lang="shell"> apt install mariadb-server </syntaxhighlight>T...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Warning Warning: These instructions were only tested on Debian. It will probably work for other Linux distributions, but you might need to adapt the provided instructions.

MariaDB is a drop-in replacement for the well-known MySQL database.

Installation

apt install mariadb-server

The installation script will prompt you for root password. This is the password for the super-administrator account of your MariaDB server. It is different from the root account of your Linux machine. Make sure you use something secure and that you remember it.

Securing

Run the following script as root

# mysql_secure_installation

The script will start by asking your MariaDB root password. It will then ask if you wand to change it. If you have set a secure password at the previous step, it is safe to answer no.

The script will then propose to you a few configuration changes. Unless you know what you are doing, accept all changes.

Testing

$ mysql -u root -p

PhpMyAdmin

PhpMyAdmin allows you to view and administrate your databases from your browser