PacktLib: Getting Started with MariaDB

Getting Started with MariaDB

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

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

Configuring MariaDB

Filesystem layout for MariaDB

Summary

MariaDB Security

Securing MariaDB in ten seconds

Connecting safely

Server security

Building security

Internal network security

Internet security

Summary

MariaDB User Account Management

User privileges

Creating users

Granting permissions

Changing passwords

Removing users

Summary

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

MariaDB Maintenance

MariaDB log files

Optimizing and tuning MariaDB

Backing up MariaDB

Making cold backups

Checking and repairing tables

Summary

MariaDB Next Steps

Index