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
About the Author
About the Reviewers
MariaDB Next Steps

User privileges

The privileges or rights that we can grant to users are many and varied. They break down into three main categories:

  • Global administrative user privileges

  • Database, table, and column user privileges

  • Miscellaneous user privileges and limits

when you look through the following tables of privileges, don't worry if you do not understand every privilege and what it means. For now, it's enough to just be aware of them and of the fact that privileges are how MariaDB controls what a user can do.

Global administrative user privileges

The following table lists the global administrative user privileges. Global privileges apply to all databases, and tables within those databases, which belong to an entire MariaDB database server or server cluster:




The ability to create a user using the CREATE USER statement.


The ability to use the LOAD DATA INFILE statement and the LOAD_FILE() function.


The ability to use the SHOW PROCESSLIST command...