{"id":46,"date":"2019-10-02T11:21:28","date_gmt":"2019-10-02T04:21:28","guid":{"rendered":"https:\/\/mariadbtutorial.com\/?page_id=46"},"modified":"2020-04-11T23:24:14","modified_gmt":"2020-04-11T16:24:14","slug":"install-mariadb","status":"publish","type":"page","link":"https:\/\/www.mariadbtutorial.com\/getting-started\/install-mariadb\/","title":{"rendered":"Install MariaDB"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn step by step how to download and install MariaDB on your system.<\/p>\n\n\n\n

Download MariaDB<\/h2>\n\n\n\n

To download MariaDB, you go to the download page and select the latest version to download:<\/p>\n\n\n\n

Download MariaDB<\/a><\/p>\n\n\n\n

Install MariaDB<\/h2>\n\n\n\n

To install MariaDB on Windows, you follow these steps:<\/p>\n\n\n\n

Step 1. Start installation<\/h3>\n\n\n\n

Double-click the installer to start the installation process.<\/p>\n\n\n\n

\"Install<\/figure>\n\n\n\n

Step 2. Accept the end-user license agreement<\/h3>\n\n\n\n

Read the end-user license agreement and click the Next button:<\/p>\n\n\n\n

\"Install<\/figure>\n\n\n\n

Step 3. Select features<\/h3>\n\n\n\n

Choose the directory that stores the MariaDB files and click the Next button. The default location on Windows is C:\\Program Files\\MariaDB 10.4\\<\/code>.<\/p>\n\n\n\n

\"Install<\/figure>\n\n\n\n

Step 4. Set root’s password<\/h3>\n\n\n\n

Type a password for the root user account. You will use this password to connect to MariaDB later.  The root user is the default user of the MariaDB, which has all privileges.<\/p>\n\n\n\n

If you don’t want the root user to login from a remote machine, you need to uncheck the Enable access from remote machines for 'root' user<\/code> checkbox.<\/p>\n\n\n\n

The Use UTF8 as the default server's character set<\/code> option allows you to use the UTF8 as the default character set when you create new databases and tables.<\/p>\n\n\n\n

Once you complete selecting all options, click the Next button to go to the next step.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 5. Configure Database<\/h3>\n\n\n\n

In this step:<\/p>\n\n\n\n

First, install MariaDB as a service by selecting the Install as service<\/code> option. It allows you to rename the service name.<\/p>\n\n\n\n

Second, configure the port for the MariaDB. By default, MariaDB uses 3306 port. However, you can change it to your port if you want.<\/p>\n\n\n\n

Third, specify the parameters for the Innodb engine including buffer pool size and page size.  16KB page size is suitable for most databases.<\/p>\n\n\n\n

Finally, click the Next button to go to the next step.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 6. Submit usage information<\/h3>\n\n\n\n

If you want to submit anonymous usage information so that MariaDB developers can improve the system, check the checkbox and click the Next button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 7.  Ready to install MariaDB<\/h3>\n\n\n\n

Click the Install button to start installing MariaDB<\/p>\n\n\n\n

\"Install<\/figure>\n\n\n\n

It will take a few minutes depending on the system.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 8. Complete the MariaDB setup<\/h3>\n\n\n\n

Click the Finish<\/strong> button to complete MariaDB setup<\/p>\n\n\n\n

\"Install<\/figure>\n\n\n\n

You can find the MariaDB tools in the startup menu:<\/p>\n\n\n\n

\"Install<\/figure>\n\n\n\n

In this tutorial, you have learned step by step how to install MariaDB on Windows.<\/p>\n

\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t