Executing the command (mysql_secure_installation) we can increase the security of our MariaDB database manager, in the execution of the script we can configure a password for the administrator user or root user of the system, Delete anonymous users, Disable remote connection of the root user and other important points that may improve the security of our MariaDB database manager.
What is MariaDB?
MariaDB is a community-developed, commercially-supported relational database manager (RDBMS) intended to remain free and open source under the GNU General Public License. The development is led by some of the original MySQL developers, who forked it due to concerns about its acquisition by Oracle Corporation in 2009.
MariaDB aimed to maintain high compatibility with MySQL, ensuring direct replaceability with library binary parity and exact match with API and MySQL commands.
Its main developer / CTO is Michael "Monty" Widenius, one of the founders of MySQL AB and founder of Monty Program AB. On January 16, 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $ 1 billion. The acquisition was completed on February 26, 2008. Oracle was purchased the following year by Oracle Corporation. MariaDB is named after Monty's youngest daughter, Maria. (MySQL is named after its other daughter, My).
Nota: For the execution of this command, the previous installation of MariaDB is necessary, in the script execution process if you have not configured a previous password, simply press Enter.
In executing the command we simply follow the steps below:
Enter current password for root (enter for none): Press Enter
Set root password? [Y/n] Y
New password: Enter the new MariaDB root password
Re-enter new password: Repeat the password
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Reload privilege tables now? [Y/n] Y