Database Reference
In-Depth Information
To download a copy of the server, go to
It is recommended that you download and install the newest version of
MariaDB (usually the first option listed). You are presented with a list of
download options for various computer platforms and operating systems.
Unlike the command line
mysql
utility, MySQL Workbench is not included
with MariaDB. Instead, it must be downloaded from
If you are
installing a local MariaDB server, do so before installing any other
clients or utilities. The installation procedure varies from platform to platform,
but all installations prompt you for needed information, including
Installation location (the default is usually fine).
■
Password for
root
user. (If you are not prompted for a
root
password
then there will be no
root
password set.)
■
Ports, service or process names, and more. As a rule, use default values
if you are unsure of what to specify.
■
Tip
Multiple MariaDB Servers Multiple copies of MariaDB server may be installed on a
single machine, as long as each uses a different port.
Note
Important Note for Windows Users When running MariaDB on Windows you want the
MariaDB server to be running as a system service. If you are installing MariaDB 5.2.6
or later, the service will be created for you as part of the installation process. For earlier
versions of MariaDB, you need to do this manually. Fortunately, this is simple to do.
Open a command prompt window (you can do this by clicking Start, Run; typing
cmd
; and
then clicking OK) and then go to the
bin
folder under the MariaDB installation folder. In
that folder type
mysqld --install
and press Enter. You should see a message telling
you that the service was created.
