Summary

Depending on your skillset, you're either an administrator that is learning about SQL databases for the first time or you're a seasoned veteran who is curious how to implement a database server with Ubuntu Server. With the recent changes in Ubuntu Server as provided by its upstream database packages, there are quite a few differences on this platform when compared to MySQL and MariaDB implementations even on other platforms (especially in regards to authentication). In this chapter, we dove into Ubuntu's implementation of this technology, and worked through setting up our own database server. We also worked through some examples of the MySQL syntax, such as creating databases, as well as setting up users and their grants. We also worked through setting up a master and slave server for replication.

Database administration is a very vast topic, and we've only scratched the surface here. Being able to manage MySQL and MariaDB databases is a very sought-after skill for sure. If you haven...