Book Image

Linux: Powerful Server Administration

By : Jonathan Hobson, William Leemans, Uday Sawant, Oliver Pelz
Book Image

Linux: Powerful Server Administration

By: Jonathan Hobson, William Leemans, Uday Sawant, Oliver Pelz

Overview of this book

Linux servers are frequently selected over other server operating systems for their stability, security and flexibility advantages.This Learning Path will teach you how to get up and running with three of the most popular Linux server distros: Ubuntu Server, CentOS 7 Server, and RHEL 7 Server. We will begin with the Ubuntu Server and show you how to make the most of Ubuntu’s advanced functionalities. Moving on, we will provide you with all the knowledge that will give you access to the inner workings of the latest CentOS version 7. Finally, touching RHEL 7, we will provide you with solutions to common RHEL 7 Server challenges.This Learning Path combines some of the best that Packt has to offer in one complete, curated package. It includes content from the following Packt products: 1)Ubuntu Server Cookbook 2)CentOS 7 Linux Server Cookbook, Second Edition 3)Red Hat Enterprise Linux Server Cookbook
Table of Contents (6 chapters)

Chapter 10. Working with Databases

In this chapter, we will cover:

  • Installing a MariaDB database server
  • Managing a MariaDB database
  • Allowing remote access to a MariaDB server
  • Installing a PostgreSQL server and managing a database
  • Configuring remote access to a PostgresSQL
  • Installing phpMyAdmin and phpPgAdmin

Introduction

This chapter is a collection of recipes that deliver the necessary steps to implement and maintain two of the most popular database management systems in the Linux world. The need for data is everywhere and is a must have service for almost any server, and this chapter provides the starting point required to deploy these database systems in any environment.

Installing a MariaDB database server

Supporting over 70 collations, more than 30 character sets, multiple storage engines, and deployment in virtualized environment, MySQL is a mission-critical database server that is used by production servers all over the world. It is capable of hosting a vast number of individual...