Finally allow MariaDB to start at system boot:
Posted: Sat Apr 05, 2025 5:10 am
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.
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.