EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 600+ Courses All in One Bundle
  • Login
Home Software Development Software Development Tutorials MariaDB Tutorial MariaDB for Windows
Secondary Sidebar
MariaDB Tutorial
  • MariaDB
    • MariaDB Versions
    • MariaDB? list users
    • MariaDB Commands
    • MariaDB odbc
    • MariaDB Workbench
    • MariaDB for windows
    • MariaDB Server
    • MariaDB? Data Types
    • MariaDB? boolean
    • MariaDB phpMyAdmin
    • MariaDB Mysqldump
    • MariaDB Java Connector
    • MariaDB insert
    • MariaDB UPDATE
    • MariaDB? rename column
    • MariaDB AUTO_INCREMENT
    • MariaDB Timezone
    • MariaDB GROUP_CONCAT
    • MariaDB wait_timeout
    • MariaDB MaxScale
    • MariaDB? with
    • MariaDB GUI
    • MariaDB? create?table
    • MariaDB? SHOW TABLES
    • MariaDB alter table
    • MariaDB List Tables
    • MariaDB JSON Functions
    • MariaDB Foreign Key
    • MariaDB? trigger
    • MariaDB Grant All Privileges
    • MariaDB Select Database
    • MariaDB? create database
    • MariaDB Delete Database
    • MariaDB Join
    • MariaDB JSON
    • MariaDB? show databases
    • MariaDB List Databases
    • MariaDB Functions
    • MariaDB? TIMESTAMP
    • MariaDB create user
    • MariaDB add user
    • MariaDB Max Connections
    • MariaDB show users
    • MariaDB Delete User
    • MariaDB? change user password
    • MariaDB? change root password
    • MariaDB reset root password
    • MariaDB IF
    • MariaDB bind-address
    • MariaDB Transaction
    • MariaDB Cluster
    • MariaDB Logs
    • MariaDB Encryption
    • MariaDB? backup
    • MariaDB Replication
    • MariaDB max_allowed_packet
    • MariaDB? performance tuning
    • MariaDB export database
    • MariaDB? import SQL

MariaDB for Windows

mariadb for windows

Introduction to MariaDB for windows

MariaDB for windows is one of the most powerful relational databases in the market, which is completely open-source and guarantees to remain open source in the future as well. It has many rich features enhancing its capability and efficiency. It is very popular among developers and comes as default in Linux operating system. However, it is available to download on many other platforms, including windows. This article will first have an overview of the MariaDB to understand its features and work. Further, we will have a look at the installation process by using the tar.gz zip file and how to download it. We will also have a look at how we can download other products and tools related to MariaDB in one of the sections.

MariaDB for Windows overview

MariaDB is one of the most popular and relational databases being used by developers. This database has been available in the market for the past 30 years and is completely open-source. It has great functionality and features, and any new additional features are added based on merit as per the MariaDB community. To use this relational database management system, you can make use of different editors; one of them is the workbench.

Download MariaDB Server for Windows –

  • To download MariaDB for windows, you will first have to visit the official link for MariaDB, which is https://downloads.mariadb.org/. You can choose the latest version or also any other depending on your requirement, and then click on Download Stable Now! As shown in the below figure –

mariadb for windows output 1

Start Your Free Software Development Course

Web development, programming languages, Software testing & others

  • With the click of that button, you can see a complete list of the package type, operating system, and the size of the file. Choose the OS like Windows and click on the file name as shown here –

mariadb for windows output 2

You can choose either the zip file or MSI file. If you are professional and clear about your needs, you can download the tar.gz file. For beginners, the most preferable way is to go for an MSI download. The file will get downloaded after you click on the blue link of its name; a new page will open where you can click on the direct download link to download it.

All in One Software Development Bundle(600+ Courses, 50+ projects)
Python TutorialC SharpJavaJavaScript
C Plus PlusSoftware TestingSQLKali Linux
Price
View Courses
600+ Online Courses | 50+ projects | 3000+ Hours | Verifiable Certificates | Lifetime Access
4.6 (86,502 ratings)

Installing MariaDB on Windows

  • To install the MariaDB, you will first have to double click on the file that will initiate the process of installation that will open up the new window, which looks as follows –\

mariadb for windows output 3

  • After that, you will get an option to read the agreement for the end-user, which you can read and then click on accept user license option and then the Next button as shown here –

mariadb for windows output 4

  • Then a new screen listing all the features will get displayed where you will need to browse and choose the desired path where the installed files will be stored in your system and then click on the Next button. In case if you do not browse the directory, then the default path chosen is inside the C drive -> Program Files folder and then inside the MariaDB 10.4 or any other version folder which will be created. The screen will look as follows –

mariadb for windows output 5

  • Thereafter it will prompt you to enter the password associated with the root user and confirm the same by writing the password again. Further, you will have to enable or disable the feature of remote access of the system’s MariaDB to the root user, which you can mark by clicking on the checkbox. The last task on this screen is to click on the third red box shown below, inside which there is a check box that stands for mentioning the character set that the server will use by default should be UTF8 or not.

output 5

  • After clicking on next in the above screen, you can observe the configuration screen that has a total of 3 sections for the name of the service that is being installed, the port number that will be used as a TCP port for communication, and the engine settings of InnoDB which consist of a specification of page size and buffer pool size. Next, you will have to tick the Install as a service option for installing MariaDB as a service and also click on the Enable Networking option, and the default port address for MariaDB is 3306; although you can mention a different one, make sure that the specified port is available and not used by any other application.

output 7

  • In case if you want to allow to submit anonymous information related to usage for improving the system by developers, you can check this check box and then click Next.

output 8

  • Click on the Install button to initiate the installation. Note that the completion time varies from system to system.

output 9

output 10

  • Finally, you can click on the Finish button to finish the setup process of installation of MariaDB on your system.

output 11

  • To confirm it, you can quickly search for MariaDB in the startup menu as shown below, where you can find the MariaDB service.

output 12

Download MariaDB Products & Tools

There are various products of the MariaDB community, some of which include MariaDB Enterprise, MariaDB community service, MariaDB cloud, and MariaDB itself. Services provided by the MariaDB community include Migration practice, Training, sky DHA, Consulting, Remote DBA, technical support, and Enterprise Architect. You can choose your desired version from the dropdown and also the operating system you are using to download the community server as shown in the below screenshot by visiting the official link https://mariadb.com/downloads/.

output 13

MariaDB also contains a new feature that will help you scale in real-time analytics called column Store. It is also compatible with the oracle database.

Conclusion

MariaDB is a completely open-source solution for having a relational database system on your machine for applications. It is loaded with rich features and is very popular among developers. You can easily download and install it on your system by following the steps mentioned in the above article. To download the external MariaDB tools and products, you can visit the official website link https://mariadb.com/downloads/ for further details.

Recommended Articles

This is a guide to MariaDB for windows. Here we discuss how we can download other products and tools related to MariaDB in one of the sections. You may also have a look at the following articles to learn more –

  1. MariaDB TIMESTAMP
  2. MariaDB List Tables
  3. MariaDB Replication
  4. MariaDB create user
Popular Course in this category
SQL Training Program (7 Courses, 8+ Projects)
  7 Online Courses |  8 Hands-on Projects |  73+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Java Tutorials
  • Python Tutorials
  • All Tutorials
Certification Courses
  • All Courses
  • Software Development Course - All in One Bundle
  • Become a Python Developer
  • Java Course
  • Become a Selenium Automation Tester
  • Become an IoT Developer
  • ASP.NET Course
  • VB.NET Course
  • PHP Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Software Development Course

C# Programming, Conditional Constructs, Loops, Arrays, OOPS Concept

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more