Getting Started with MariaDB

Getting Started with MariaDB
eBook: $20.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $55.98    Print cover: $34.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 100 pages [ 235mm x 191mm ]
Release Date : October 2013
ISBN : 1782168095
ISBN 13 : 9781782168096
Author(s) : Daniel Bartholomew
Topics and Technologies : All Books, Big Data and Business Intelligence, Open Source

Table of Contents

Chapter 1: Installing MariaDB
Chapter 2: Configuring MariaDB
Chapter 3: MariaDB Security
Chapter 4: MariaDB User Account Management
Chapter 5: Using MariaDB
Chapter 6: MariaDB Maintenance
Appendix: MariaDB Next Steps
  • Chapter 1: Installing MariaDB
    • Choosing a MariaDB series
      • The development series
      • The stable series
      • The maintenance 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
        • Filesystem layout for Windows
        • Filesystem layout for Linux
        • Modular configuration on Linux
        • The MariaDB configuration file
        • Comments
        • Groups
        • Options which do not require values
        • Options which require values
        • Options, options everywhere
        • Activating configuration changes
      • 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
            • Global administrative privileges
            • Database, table, and column privileges
            • Miscellaneous privileges and limits
          • Creating users
          • Granting permissions
            • Adding and removing privileges
            • Showing grants
          • Changing passwords
          • Removing users
          • Summary
          • Chapter 5: Using MariaDB
            • Running the mysql command-line client
            • Using a database
              • Listing all databases on a server
            • Creating and dropping databases
              • Creating a database
              • Dropping a database
            • Creating, altering, and dropping tables
              • Creating a table
                • Showing the command used to create a table
                • Exploring the structure of a table
              • Altering a table
                • Adding a column
                • Modifying a column
                • Dropping a column
              • Dropping a table
            • Selecting, inserting, updating, and deleting data
              • Inserting data
              • Updating data
              • Deleting data
              • Reading data
            • Summary
            • Chapter 6: MariaDB Maintenance
              • MariaDB log files
                • The all-important binary log
                • The error log
                • The general query log
                • The slow query log
              • Optimizing and tuning MariaDB
              • Backing up MariaDB
                • Basic backups with mysqldump
                • Restoring and importing data with mysqlimport
                • Making backups of MyISAM tables quickly with mysqlhotcopy
              • Making cold backups
              • Checking and repairing tables
                • Checking and optimizing tables with mysqlcheck
                • Repairing tables
              • Summary

              Daniel Bartholomew

              Daniel Bartholomew has been using Linux since 1997 and databases since 1998. He is a frequent contributor to various magazines, including The Linux Journal, Linux Pro, Ubuntu, User, and Tux.

              He has been involved with the MariaDB project since shortly after it began in early 2009. He currently works for SkySQL and splits his time between MariaDB documentation and maintaining the bits and pieces (including build, e-mail, web, and other servers), which keeps the MariaDB project running smoothly. In addition to his day-to-day responsibilities, he also serves as the MariaDB release coordinator and has been deeply involved with almost every MariaDB release.

              He lives in Raleigh, North Carolina, U.S.A. with his lovely wife and awesome children.

              Code Downloads

              Download the code and support files for this book.

              Submit Errata

              Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

              Sample chapters

              You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

              Frequently bought together

              Getting Started with MariaDB +    Responsive Web Design – From Concept to Complete Site [Video] =
              50% Off
              the second eBook
              Price for both: £13.99

              Buy both these recommended eBooks together and get 50% off the cheapest eBook.

              What you will learn from this book

              • 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.


              A practical, hands-on, beginner-friendly guide to installing and using MariaDB.

              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.

              Code Download and Errata
              Packt Anytime, Anywhere
              Register Books
              Print Upgrades
              eBook Downloads
              Video Support
              Contact Us
              Awards Voting Nominations Previous Winners
              Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
              Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software