Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- 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 -- Appendix: MariaDB Next Steps -- Index.