Book Image

Getting Started with MariaDB

By : Daniel Bartholomew
Book Image

Getting Started with MariaDB

By: Daniel Bartholomew

Overview of this book

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.

Related Content you might be interested in

Current Title:

Small book image
Getting Started with MariaDB
Daniel Bartholomew
Jun, 2015 | 140 pages
No titles found
Table of Contents (16 chapters)
Getting Started with MariaDB Second Edition
Getting Started with MariaDB Second Edition
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Installing MariaDB
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
2
Configuring MariaDB
Configuring MariaDB
The MariaDB filesystem layout
Modular configuration on Linux
The anatomy of the MariaDB configuration file
Activating configuration changes
Summary
3
Securing MariaDB
Securing MariaDB
Security layers
Securing MariaDB in 10 seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
4
Administering MariaDB
Administering MariaDB
User privileges
Creating users
Granting, revoking, and showing permissions
Setting and changing passwords
Removing users
Summary
5
Using MariaDB – Databases and Tables
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
6
Using MariaDB – Inserting, Updating, and Deleting
Using MariaDB – Inserting, Updating, and Deleting
Using INSERT
Using UPDATE
Using DELETE
Summary
7
Using MariaDB – Retrieving Data
Using MariaDB – Retrieving Data
Retrieving data
Filtering and searching data
Summarizing data
Summary
8
Maintaining MariaDB
Maintaining MariaDB
MariaDB log files
Optimizing and tuning MariaDB
Backing up, importing, and restoring data
Repairing MariaDB
Summary
MariaDB Next Steps
MariaDB Next Steps
Index
Index

Getting Started with MariaDB Second Edition

Copyright © 2015 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: June 2015

Production reference: 1120615

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78528-412-0

www.packtpub.com

Previous Section
Next Chapter