From the course: Linux System Engineer: Database Servers Using MariaDB

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Secure a MariaDB server

Secure a MariaDB server

From the course: Linux System Engineer: Database Servers Using MariaDB

Start my 1-month free trial

Secure a MariaDB server

“

- [Instructor] A script is included in the MariaDB Server package called MySQL Secure Installation, and that helps secure common items making MariaDB harder to exploit. Let's run this script now. In a Terminal type mySQL_secure_installation and hit Enter. The first thing that happens is the script prompts you for the database root user's password. As such, this script is good for setting the initial password, but not for recovering it like we did in a previous video. Enter your database root user's password now. Note that we set this earlier in this chapter. Now it will prompt you to reset the root user's password if you wish. Press N for no since we've already done it. The next prompt asks if you want to remove the default MariaDB anonymous user. Say yes to remove the anonymous user by pressing Y now. Next we will secure where the MariaDB root user can login from. That user should never be logging in remotely so let's restrict it now. Say yes to restricting remote logins by pressing…

Contents