Getting Started with MariaDB

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.
Preview in Mapt

Getting Started with MariaDB

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.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$14.70
RRP $20.99
Save 29%
Print + eBook
$34.99
RRP $34.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$14.70
$34.99
$29.99p/m after trial
RRP $20.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Getting Started with MariaDB Book Cover
Getting Started with MariaDB
$ 20.99
$ 14.70
Getting Started with MariaDB - Second Edition Book Cover
Getting Started with MariaDB - Second Edition
$ 19.99
$ 14.00
Buy 2 for $28.70
Save $12.28
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781782168096
Paperback100 pages

Book Description

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.

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

Authors

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

Book Details

ISBN 139781782168096
Paperback100 pages
Read More

Read More Reviews

Recommended for You

Git: Version Control for Everyone Book Cover
Git: Version Control for Everyone
$ 23.99
$ 16.80
CentOS 6 Linux Server Cookbook Book Cover
CentOS 6 Linux Server Cookbook
$ 29.99
$ 21.00
Linux Shell Scripting Cookbook, Second Edition Book Cover
Linux Shell Scripting Cookbook, Second Edition
$ 26.99
$ 5.40
MariaDB Cookbook Book Cover
MariaDB Cookbook
$ 29.99
$ 21.00
Git Version Control Cookbook Book Cover
Git Version Control Cookbook
$ 26.99
$ 18.90
Learning Docker Book Cover
Learning Docker
$ 39.99
$ 8.00