Difference between revisions of "MariaDB"

From wiki
m (Add WIP warning)
(sudo)
 
(4 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
=== Securing ===
 
=== Securing ===
 
Run the following script as root<syntaxhighlight lang="console">
 
Run the following script as root<syntaxhighlight lang="console">
# mysql_secure_installation
+
$ sudo mysql_secure_installation
 
</syntaxhighlight>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.
 
</syntaxhighlight>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.
  
Line 19: Line 19:
  
 
== PhpMyAdmin ==
 
== PhpMyAdmin ==
PhpMyAdmin allows you to view and administrate your databases from your browser
+
You can now install [[PhpMyAdmin]]. It allows you to view and administrate your databases from your browser.
 +
 
 +
 
 +
[[Category:Linux Server]]

Latest revision as of 15:20, 22 August 2018


Warning Warning: This page is a work in progress and is not completed. Important informations might be missing or wrong.
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

$ sudo 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

You can now install PhpMyAdmin. It allows you to view and administrate your databases from your browser.