From the course: Ubuntu Linux: Providing Services

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Configure a database server

Configure a database server

From the course: Ubuntu Linux: Providing Services

Start my 1-month free trial Buy for my team

Configure a database server

“

- [Instructor] Databases store information that can be used by various kinds of tools and applications. There are many different database packages out there, and one of the most common is called MariaDB. Let's take a look at configuring our Linux system to act as a database server. We can install MariaDB with apt install mariadb-server, but once it's installed we'll still need to configure it. To configure my server I'll run sudo mysql_secure_installation. The root user for this database has no password so I'll press Enter. I'm asked if I want to switch to Unix socket authentication. If you plan on using the database directly from the server you might choose yes, but I'm going to choose no. It's a good idea to set a root password, so I'll do that. And I'll confirm the password. We'll remove anonymous users, and we'll prevent the root user from logging in remotely. Later, we'll create another user account. I'll remove the test database, and I'll reload the privilege tables. To connect…

Contents