Book Image

Getting Started with MariaDB

By : Daniel Bartholomew
Book Image

Getting Started with MariaDB

By: Daniel Bartholomew

Overview of this book

<p>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.</p> <p>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.</p> <p>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.</p>
Table of Contents (14 chapters)

Removing users


To remove a user completely, we use the DROP USER statement. It has the following pattern:

DROP USER <user>;

Here is an example:

DROP USER 'tom'@'%';

When a user is dropped, all grants are automatically removed.

Complete documentation of the DROP USER statement is available at https://mariadb.com/kb/en/drop-user/.