Free Sample
+ Collection

Getting Started with MariaDB

Starting
Daniel Bartholomew

MariaDB is growing in popularity as a “drop-in” replacement for MySQL. Now you can quickly learn how to install and configure it to meet your own data storage needs in this beginner-friendly tutorial.
$20.99
$34.99
RRP $20.99
RRP $34.99
eBook
Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781782168096
Paperback100 pages

About This Book

  • A step-by-step guide to installing and configuring MariaDB
  • Includes real-world examples that help you learn how to store and maintain data on MariaDB
  • Written by someone who has been involved with the project since its inception

Who This Book Is For

Getting Started with MariaDB is for anyone who wants to learn more about databases in general or MariaDB in particular. No prior database experience is required. It is assumed that you have basic knowledge of software installation, editing files with a text editor, and using the command line and terminal.

Table of Contents

Chapter 1: Installing MariaDB
Choosing a MariaDB series
Installing MariaDB on Windows
Installing MariaDB on Mac OS X
Installing MariaDB on Debian, Ubuntu, and Linux Mint
Installing MariaDB on Fedora, Red Hat, and CentOS
Installing MariaDB on other Linux distributions
MariaDB package security
After the installation
Troubleshooting installation issues
Summary
Chapter 2: Configuring MariaDB
Filesystem layout for MariaDB
Summary
Chapter 3: MariaDB Security
Securing MariaDB in ten seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
Chapter 4: MariaDB User Account Management
User privileges
Creating users
Granting permissions
Changing passwords
Removing users
Summary
Chapter 5: Using MariaDB
Running the mysql command-line client
Using a database
Creating and dropping databases
Creating, altering, and dropping tables
Selecting, inserting, updating, and deleting data
Summary
Chapter 6: MariaDB Maintenance
MariaDB log files
Optimizing and tuning MariaDB
Backing up MariaDB
Making cold backups
Checking and repairing tables
Summary

What You Will Learn

  • Install MariaDB on Windows/RedHat/Fedora/CentOS Linux/Debian/Ubuntu Linux
  • Configure MariaDB to optimize data storage
  • Administer users on MariaDB
  • Learn how to utilize MariaDB to maintain a backup of your data
  • Maintain MariaDB and keep it running smoothly

In Detail

In the modern age, storing data is of paramount importance, and this is where databases enter the picture. MariaDB is a relatively new database that has become very popular in a short amount of time. It is a community-developed fork of MySQL and it is designed to be an enhanced and backward compatible database solution.

Getting Started with MariaDB is a practical, hands-on, beginner-friendly guide to installing and using MariaDB. This book will start with the installation of MariaDB before moving on to the basics. You will then learn how to configure and maintain your database with the help of real-world examples.

Getting Started with MariaDB literally starts at square one by walking you through the basics of what you need to know about MariaDB. This book will teach you how to install MariaDB as well as how to configure it. Following that, you will then be shown how to secure MariaDB. This book will also teach you common commands and will help you learn how to maintain a MariaDB server.

Authors

Read More