If you want to make advanced applications, it’s obvious that you require some kind of database to store and retrieve information. There are many types of databases available. MySQL is a very popular relational database which you can use in the backend of your application to store information and use that information when required.
MySQL has a version for Mac as well. You can install it to build powerful applications. Apart from that, you can also use it to practice your SQL concepts. After installation, you can run it from the terminal and also use it with other tools such as phpMyAdmin. Let us see how to install MySQL on your Mac computer.
- For general purposes, it is recommended to install the community edition of MySQL. Click on this link to go to the download page.
- Click on the download button after selecting your OS version. It will download the dmg file in your computer. Remember, its important to download the correct file compatible with your device hardware and operating system.
- Open the dmg file and double click on the installation package. You will see the installation wizard. Click continue.
- You have to agree to the license agreement and proceed.
- You have to set a password for the root user. This is the password you will use everytime you want to access MySQL. Then, click on finish.
- You will see the screen stating that you have successfully installed MySQL.
- To check if everything is fine and to use it paste this command in the terminal :
/usr/local/mysql/bin/mysql -u root -p
- You will be prompted to enter your password. Enter it and you are good to go. Type show databases command to test.
- Thats it. You have successfully installed MySQL on your Mac. Now you can perform various operations using SQL like creating databases, tables,etc.
Thanks for reading. Hope this post helped you in some way. Keep visiting iCuriousGeek!