How to Install MySQL on MacOS?

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.

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

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.

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

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

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

Step 7: Wait for the installation process to complete.

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

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

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

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

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

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

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;

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>;

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

show databases;

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!