Finally allow MariaDB to start at system boot:

Where business professionals discuss big database and data management.
Post Reply
Mitu100@
Posts: 1391
Joined: Tue Jan 07, 2025 4:29 am

Finally allow MariaDB to start at system boot:

Post by Mitu100@ »

Hence, you need to tweak the settings, test the database, and delete the anonymous users.

1. Start by entering the command:

sudo mysql_secure_installation



2. You will be prompted for the root password for MariaDB (this is not the root password for your server).
Since you don't have a phone number library password yet, pressing Enter allows you to continue with the setup.

4. Then he will ask you a series of questions. To keep your database secure, please answer the following questions:
Set root password? [Y/n] Y
New password: enter the password you want to use.
Re-enter new password: enter the password from the previous field again.
Remove anonymous users? [Y/n] Y
Prevent remote root login? [Y/n] Y
Do you want to delete and access the test database? [Y/n] Y
Reload privilege tables now? [Y/n] Y

5. After answering the questions, the output will display a message that your system is being cleaned up and the installation should now be secure.


sudo systemctl enable mariadb.service



Step 5. Install PHP
As a server-side scripting language, PHP is part of the LAMP group that processes code to render dynamic content.
Post Reply