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

Activating configuration changes

The last stop on our highlights tour of MariaDB configuration is how to activate the changes, once we've made them. To do so, we need to reload or restart MariaDB.

In Windows, we perform the following commands to stop and start MariaDB, respectively:

sc stop mysql
sc start mysql

The preceding two commands assume that we set the service name to mysql (the default) during installation. If we set it to a different name, such as mariadb, we would specify that instead.

On Linux systems, the way to activate configuration changes is to reload MariaDB. Traditionally, this is done by doing the following (and we may need to preface it with sudo):

/etc/init.d/mysql reload

However, on some systems, the preferred way to reload MariaDB is as follows:

service mysql reload

One or the other, and possibly both, will work.

We can also use the SET command to temporarily set the options. See the MariaDB Knowledge Base for more information on using this command from: