![]() ![]() This will remove some anonymous users and the test database, disable remote root logins, and load these new rules so that MariaDB immediately implements the changes you have made. Later, you’ll go over how to set up an additional administrative account for password access if socket authentication is not appropriate for your use case.įrom there, you can press Y and then ENTER to accept the defaults for all the subsequent questions. Since you have not set one up yet, press ENTER to indicate “none”. The first prompt will ask you to enter the current database root password. This will take you through a series of prompts where you can make some changes to your MariaDB installation’s security options. This script changes some of the less secure default options for things like remote root logins and sample users. Step 2 - Configuring MariaDBįor new MariaDB installations, the next step is to run the included security script. Because the default configuration leaves your installation of MariaDB insecure, you will use a script that the mariadb-server package provides to restrict access to the server and remove unused accounts. These commands will install MariaDB, but will not prompt you to set a password or make any other configuration changes. To install it, update the package index on your server with apt: It is marked as the default MySQL variant by the Debian MySQL/MariaDB packaging team. Set this up by following our initial server setup guide for Debian 11.Īs of this writing, Debian 11’s default software repositories include MariaDB version 10.5.15. This server should have a non-root administrative user and a firewall configured with UFW. ![]() To follow this tutorial, you will need a server running Debian 11. ![]() This tutorial will explain how to install MariaDB on a Debian 11 server and verify that it is running and has a safe initial configuration.
0 Comments
Leave a Reply. |