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.
Table of Contents (16 chapters)
Getting Started with MariaDB Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
MariaDB Next Steps
Index

Server security


With MariaDB itself locked down nice and tight, and by using good password practices, we now need to look at the computer that MariaDB is running on.

If we are running MariaDB on our own desktop or laptop, and we are the only one who can log into it, then there's not much to worry about apart from the normal things we do to keep our computer secure, such as virus and malware protection, system updates, keeping it in a secure location, and so on. It is also useful to encrypt our hard drives, or at least our home folders, using an operation supported by most modern operating systems.

When we install MariaDB on a dedicated server then there is more that we have to worry about. Servers are almost always multiuser, so as part of server security, we need to know who can log in and most importantly, who has root or administrator access. If we are the administrator of the machine, we can ensure that only those we want to have access to the administrator or root have access. If we're...