Book Image

CentOS 7 Server Deployment Cookbook

By : Timothy Boronczyk, IRAKLI NADAREISHVILI
Book Image

CentOS 7 Server Deployment Cookbook

By: Timothy Boronczyk, IRAKLI NADAREISHVILI

Overview of this book

CentOS is derived from Red Hat Enterprise Linux (RHEL) sources and is widely used as a Linux server. This book will help you to better configure and manage Linux servers in varying scenarios and business requirements. Starting with installing CentOS, this book will walk you through the networking aspects of CentOS. You will then learn how to manage users and their permissions, software installs, disks, filesystems, and so on. You’ll then see how to secure connection to remotely access a desktop and work with databases. Toward the end, you will find out how to manage DNS, e-mails, web servers, and more. You will also learn to detect threats by monitoring network intrusion. Finally, the book will cover virtualization techniques that will help you make the most of CentOS.
Table of Contents (18 chapters)
CentOS 7 Server Deployment Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface

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:

    yum install mysql57-community-release-el7-7.noarch.rpm
    
  3. Now that the MySQL repository is registered, install the mysql-community-server package:

    yum install mysql-community-server
    
  4. Start the MySQL server and enable it to start automatically...