Getting Started with MariaDB - Second Edition

Explore the powerful features of MariaDB with practical examples
Preview in Mapt

Getting Started with MariaDB - Second Edition

Daniel Bartholomew

1 customer reviews
Explore the powerful features of MariaDB with practical examples
Mapt Subscription
FREE
$29.99/m after trial
eBook
$14.00
RRP $19.99
Save 29%
Print + eBook
$24.99
RRP $24.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.00
$24.99
$29.99 p/m after trial
RRP $19.99
RRP $24.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Getting Started with MariaDB - Second Edition Book Cover
Getting Started with MariaDB - Second Edition
$ 19.99
$ 14.00
Building Microservices with .NET Core 2.0 - Second Edition Book Cover
Building Microservices with .NET Core 2.0 - Second Edition
$ 35.99
$ 25.20
Buy 2 for $31.50
Save $24.48
Add to Cart

Book Details

ISBN 139781785284120
Paperback140 pages

Book Description

MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available.

From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it.

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
The MariaDB filesystem layout
Modular configuration on Linux
The anatomy of the MariaDB configuration file
Activating configuration changes
Summary
Chapter 3: Securing MariaDB
Security layers
Securing MariaDB in 10 seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
Chapter 4: Administering MariaDB
User privileges
Creating users
Granting, revoking, and showing permissions
Setting and changing passwords
Removing users
Summary
Chapter 5: Using MariaDB – Databases and Tables
The mysql command-line client application
Connecting to MariaDB
Using USE to select a database
Using SHOW to list all databases on a server
Creating and deleting databases
Data, tables, and normalization
Creating, altering, and dropping tables
Summary
Chapter 6: Using MariaDB – Inserting, Updating, and Deleting
Using INSERT
Using UPDATE
Using DELETE
Summary
Chapter 7: Using MariaDB – Retrieving Data
Retrieving data
Filtering and searching data
Summarizing data
Summary
Chapter 8: Maintaining MariaDB
MariaDB log files
Optimizing and tuning MariaDB
Backing up, importing, and restoring data
Repairing MariaDB
Summary

What You Will Learn

  • Install MariaBD on Windows, Mac OS X, and Linux
  • Configure MariaDB for better performance using the features of version 10
  • Get familiar with the usage of operators for retrieving rows more selectively
  • Use MariaDB 10's powerful tools to store, retrieve, and analyze data
  • Secure MariaDB from unauthorized access
  • Maintain the databases associated with MariaDB to ensure efficient and optimum functioning
  • Retrieve data and learn how to sort, summarize, group, and manipulate it.

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
The MariaDB filesystem layout
Modular configuration on Linux
The anatomy of the MariaDB configuration file
Activating configuration changes
Summary
Chapter 3: Securing MariaDB
Security layers
Securing MariaDB in 10 seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
Chapter 4: Administering MariaDB
User privileges
Creating users
Granting, revoking, and showing permissions
Setting and changing passwords
Removing users
Summary
Chapter 5: Using MariaDB – Databases and Tables
The mysql command-line client application
Connecting to MariaDB
Using USE to select a database
Using SHOW to list all databases on a server
Creating and deleting databases
Data, tables, and normalization
Creating, altering, and dropping tables
Summary
Chapter 6: Using MariaDB – Inserting, Updating, and Deleting
Using INSERT
Using UPDATE
Using DELETE
Summary
Chapter 7: Using MariaDB – Retrieving Data
Retrieving data
Filtering and searching data
Summarizing data
Summary
Chapter 8: Maintaining MariaDB
MariaDB log files
Optimizing and tuning MariaDB
Backing up, importing, and restoring data
Repairing MariaDB
Summary

Book Details

ISBN 139781785284120
Paperback140 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Learning Linux Shell Scripting Book Cover
Learning Linux Shell Scripting
$ 39.99
$ 28.00
CentOS 7 Linux Server Cookbook - Second Edition Book Cover
CentOS 7 Linux Server Cookbook - Second Edition
$ 39.99
$ 28.00
Modular Programming with PHP 7 Book Cover
Modular Programming with PHP 7
$ 39.99
$ 28.00
RESTful Web API Design with Node.js - Second Edition Book Cover
RESTful Web API Design with Node.js - Second Edition
$ 23.99
$ 16.80
Learning PHP 7 High Performance Book Cover
Learning PHP 7 High Performance
$ 31.99
$ 22.40
Spring MVC: Beginner's Guide - Second Edition Book Cover
Spring MVC: Beginner's Guide - Second Edition
$ 35.99
$ 25.20