CentOS 6 Linux Server Cookbook

Chapter 8. Working with Databases

In this chapter, we will cover:

• Installing and hardening MySQL server with mysql_secure_installation
• Creating a MySQL database, adding a MySQL user, and assigning user privilege from the command line
• Installing PostgreSQL, adding a user, and creating your first database
• Configuring remote access to PostgreSQL server

Introduction

This chapter is a collection of recipes that delivers the necessary steps that will enable you to deploy the most common database systems by showing you how to consider installing and hardening MySQL server with mysql_secure_installation; creating a MySQL database, adding a MySQL user and assigning user privilege from the command line; installing PostgreSQL, adding a user and creating your first ...