SQL is a language that was specifically designed to make it easy for other programs to access data through databases. Programs that want the database software to handle the low-level work of managing data will simply use SQL to give the proper instuctions.
There are many databases that support the use of SQL to access their data, like MySQL and PostgreSQL. In other words, MySQL is just the brand of one database software, one of many. The same goes for PostgreSQL. These two databases are very popular among programs that run on websites (probably because they are free).
There is a great guide on how to install MySQL on your Mac here. It might be a different since the OS and MySQL versions are a bit older but this shouldn't pose a problem.
Don't forget to add the mysql download to your path so that you can use the mysql
command from the command line.
If you are using bash for terminal (the default on OS X) you will need either the
~/.bashrc file or ~/.bash_profile.
Open the file with some text editor and add the following line:
export PATH=$PATH:/usr/local/mysql/binSave it and then use the following command in your terminal:
$ source ~/.bashrc
After this, you can test it as follows:
$ mysql --version
mysql Ver 8.0.13 for macos10.14 on x86_64 (MySQL Community Server - GPL)
You can find an excellent step-by-step guide here.