Open In App

How to Install MySQL on MacOS?

Improve
Improve
Like Article
Like
Save
Share
Report

MySQL is an open-source relational database managing system. It is used for implementing databases. For any website or any other application, a database is required to store data of websites and applications. Using MySQL server of data can be created. The database created by MySQL is well-organized and consistent. we can extract data from the database using queries. It is the same operation as we do in SQL query language.

In this article, we will are going to download and install MySQL on MacOS and will verify MySQL installation by creating a database. But Before that Let’s see some features of MySQL.

Features of MySQL

MySQL follows key database properties i.e. ACID (Atomicity, Consistency, Isolation, Durability), ensuring data integrity, providing high performance, scalability, and flexibility, and being open-source.

  • It is open source and easy to download and install.
  • It is a very fast database language.
  • Implementing a database and using is very simple.
  • It can be installed in any operating system.
  • It easily grows with data and application needs.
  • It ensures data integrity with transaction support.

Read more: MySQL and its working

Steps to Install MySQL on MacOS

To install MySQL on macOS follow the following steps

Step 1: Go to the official website of MySQL using any browser and  Scroll down there you will find the following link.

Install-MySQL-on-MacOS_1

Step 2: Then click on the MySQL Community Server link.

Install-MySQL-on-MacOS_2

Step 3: If you are using the latest machine, you can simply click download there. But if you are using an older machine then go for archives. As my machine is an older one I have to move to Archives.

Install-MySQL-on-MacOS_3

Step 4: Then choose the version there and download the proper software.

Install-MySQL-on-MacOS_4

Step 5: Then start the MySQL installation process, and click on the continue button.

Install-MySQL-on-MacOS_5

Step 6: Then click on the install button to move forward.

Install-MySQL-on-MacOS_6

Step 7: Wait for the installation process to complete.

Install-MySQL-on-MacOS_7

Step 8: Then click on the Next button for the next process.

Install-MySQL-on-MacOS_8

Step 9: Provide some strong passwords and then click on the Finish button.

Install-MySQL-on-MacOS_9

Step 10: Wait for some time till the process is going on.

Install-MySQL-on-MacOS_10

Step 11: Then you will find your installation is successful.

Install-MySQL-on-MacOS_11

Step 12: At last, go to system preferences, there you will find MySQL is installed.

Install-MySQL-on-MacOS_12

Hence, MySQL installation is successfully done! Now, Let’s verify if MySQL is successfully installed or not.

How to use MySQL?

Steps for using MySQL:

Step 1: To work with MYSQL, you must open your terminal. Then navigate to the installed folder.

Step 2: Then you have to run the following command. Whenever you need to work in MySQL, this command should be run first.

mysql -u root -p

Create-Database_1

Step 3: Then MySQL will start working. Then write the following command. This command will show how many databases are there in your MySQL Server.

show databases;

Create-Database_2

Step 4: Now, if you want to add a new database, you need to run the following command. It will create a new database.

create database <database_name>;

Create-Database_3

Step 5: Then again run the following command, there you will find your database is added to MySQL.

show databases;

Create-Database_4

Hence, we have successfully created a database using create database command. You are now ready to start using MySQL. MySQL is the best relational database that will keep all your data secure. Many Companies use MySQL because of its solid data security and is supported by multiple applications. So Install MySQL in MacOS now and learn SQL in 30 Days – From Basic to Advanced Level!

Also Read



Last Updated : 09 Jan, 2024
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads