Setting up a MySQL database

This recipe shows you how to perform a basic installation of the popular MySQL database server on CentOS. MySQL is the second most widely used database system today, which is found across many different industries providing data storage for everything from dynamic websites to large-scale data warehouses.

Getting ready

This recipe requires a CentOS system with a working network connection and administrative privileges either using the root account or sudo.

How to do it...

Follow these steps to install MySQL and create a new database:

  1. Download the repository configuration package for the Oracle-maintained MySQL repository:
    curl -LO dev.mysql.com/get/mysql57-community-release-el7-
           7.noarch.rpm
    
  2. Install the downloaded package: ...

Get CentOS 7 Server Deployment Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.