1. Download Mysql Server
2. Install Mysql Server Mac Terminal
3. Install Mysql Server In Mac

In this tutorial we will learn to install Apache, MySQL, PHP on macOS Catalina 10.15.

Jan 07, 2015 I am running Ubuntu 12.04 LTS and OpenSSH on an old Mac mini and connecting via my new Mac mini running OS X Mavericks (10.9.) Some reference books leave out details like the script that starts the server which you need to know to do a restart after configuration change or how to simply verify that the server is listening on a port, for example. MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download.

About macOS Catalina

Apple released macOS Catalina 10.15 on 7th October 2019 and it includes Apache and PHP. So, all we have to do is enable them. Then install MySQL and we are ready for development. So, lets get started.

Note! Support for 32 bit apps is removed in Catalina so, all your 32 bit applications will no longer work. Kindly upgrade your applications.

Apple has also made zsh as the default shell. You can learn more about it here.

To change the default shell check the tutorial How to change default shell to bash on macOS Catalina.

We will be using the pre-installed Apache and PHP and we will download and setup MySQL database.

If you are using macOS Mojave then check out this tutorial How to install Apache, MySQL, PHP on macOS Mojave 10.14

Lets go ahead and configure our LAMP stack development environment on macOS Catalina.

Apache

The new macOS Catalina comes with Apache pre-installed. All we have to do is switch it on.

Open Terminal using macOS Spotlight or go to /Applications/Utilities and open Terminal.

To check the version of Apache installed run the following command in the Terminal.

Note! macOS Catalina comes with Apache 2.4.41

To start Apache web server run the following command.

This command will start Apache server.

When you use sudo in the terminal then you will be prompted to enter your admin password to proceed.

If you want to stop the Apache server then run the following command.

And to restart Apache server run the following command.

After starting Apache server go ahead and test it by opening a browser like Safari or Chrome and visit http://localhost.

You will get to see the following output in your browser.

By default, the file is getting served from /Library/WebServer/Documents directory. We will change this is the following sections.

In case you don't get to see the above output then run the following command to check the error.

Document Root

This is the location in the computer file system from where the files are accessed when we visit the http://localhost in a browser.

Document Root is a directory where we put our website files.

On Mac we have two document root. One is at the system level and the other is at the user level.

System level document root

The system level document root in macOS Catalina is located in the following directory.

Download Mysql Server

User level document root

For the user level we can create a directory called Sites in user directory. So, open Terminal and get ready to create the user level document root directory.

Creating Sites directory

Run the following command in the Terminal to switch to the user home directory.

Now, run the following command to create the Sites directory.

You can merge the above two commands into one by running the following command.

For me the user document root path is the following.

You will get a similar path for your Mac.

Creating username.conf file

Now, we will create a username.conf file to configure our document root.

Note! Replace the username with your username.

For example, my username is yusufshakeel so, my file is yusufshakeel.conf.

Type the whoami command in the terminal and it will tell you your username.

Open terminal and go to the following directory.

Now create the configuration file username.conf inside the users directory.

In the following example I am using vi editor. You can use other editors like vim or nano.

Press the i key to enter into INSERT mode and then type the following in the file.

Don't forget to replace YOUR_USER_NAME with your username.

Here is what I have written in my yusufshakeel.conf file.

Now, come out of the INSERT mode by pressing the Esc key. Now save the file and exit by typing the following :wq and then hit Enter.

The permission of this file should be the following.

You can change the permission by typing the following command.

Where, username is your username that you have set.

Configuring the httpd.conf file

Now we switch to apache2 directory by typing the following command in the Terminal.

Inside this directory we have the httpd.conf file.

As a good practice we will make a backup copy of the httpd.conf file by typing the following command.

Now open the httpd.conf file using vi and uncomment the following lines.

To uncomment the lines remove the # from the start of the line.

Uncomment the following line for User home directories.

Now change the DocumentRoot.

Find the following lines and comment them by adding # at the beginning of the line.

And add the following two lines below the commented lines.

Don't forget to replace YOUR_USERNAME with your username.

And set the AllowOverride None to AllowOverride All.

Your DocumentRoot should now look something like the following.

Now, come out of the INSERT mode by pressing the Esc key. And save and exit the file by typing :wq key and then Enter.

Configuring the httpd-userdir.conf file

Now, time to make some changes in the httpd-userdir.conf file.

In the terminal type the following command to go to the extra directory.

As a good practice create a backup copy of the httpd-userdir.conf file.

Now open the file using vi.

Enter into INSERT mode and uncomment the following line.

Now, come out of the INSERT mode and save the changes.

Install Mysql Server Mac Terminal

Now, check if everything is configured properly by typing the given command.

Now restart Apache using the following command.

PHP

macOS Catalina comes with PHP 7.3.8 pre-installed.

To check the version of PHP in the Terminal type the following command.

Now we go to the apache2 directory.

Next, we open the httpd.conf file.

Now, enter into INSERT mode and uncomment the following line to run PHP 7 by removing the # sign from the start of the line.

Now, save the changes and exit the file by typing :wq keys and hit Enter.

You can now restart Apache by running the following command.

Printing phpinfo

Create index.php file inside the Sites directory.

Now open the file in your favourite text editor or PHP IDE and write the following code.

Now, visit http://localhost and you will get to see a similar output.

Download MySQL community server

Install Mysql Server In Mac

Head over to mysql.com website and download the latest version of the MySQL Community Server.

Download and run the installer and follow the steps to install MySQL database on your Mac.

Set the root password when prompted and note it down.

To run MySQL server open System Preferences and go to MySQL.

Click on the Start MySQL Server button to start the server.

You will be asked to enter your admin password. Enter the password and the MySQL server will start running.

Extra

To access your MySQL database tables you can either use phpMyAdmin, MySQL Workbench or Sequel Pro.

Alright, this brings us to the end of this tutorial. Hope this helped. Please share if you find this website useful. Have fun developing. See you in the next tutorial.

Install and configure a MySQL database

To install the database, you don't need to install Microsoft .NET Framework 3.5. If you run into any issues installing and configuring the database, look at the README.txt file included in the DMG Archive for some useful tips.

1. Download MySQL Community Server 5.5 DMG Archive.
2. Double-click the DMG Archive, and then double-click the .pkg file that starts with mysql-5.5. Follow the instructions to install the MySQL server.
3. Double-click the MySQLStartupItem.pkg file, and follow the instructions in the setup wizard. The wizard installs the MySQL server as an auto-startup item.
4. Double-click the MySQL.prefPane file. The file installs the MySQL control panel into the System Preferences application so that you can control the MySQL server.
5. Open the System Preferences application, and perform the following actions:
   1. In the Other section, click the MySQL icon.
   2. Click Start MySQL server to start the server.
   3. At the bottom of the control panel, you can also configure the MySQL server to run automatically on startup.
6. To make it easier to access the mysql and mysqladmin programs, you can modify the PATH environment variable by performing the following actions:
   1. From a terminal window in your home directory, type the following command:
   2. Add the following statement to your existing PATH environment variable, or create a new entry if a PATH variable isn't already defined:
   3. Close the current terminal window, and open a new one for the changes to the PATH variable to take effect.
7. From the terminal window, type the following command to set the root password:
8. Change some of the default configuration values for MySQL so that they're more suitable for the Push Service SDK by performing the following actions:
   1. From a terminal window, type the following commands to copy one of the sample MySQL configuration files so that you can modify it:
   2. Open the configuration file by typing the following command:
   3. Add the following statements to the [mysqld] section of my.cnf file:

      The first statement configures the database so that it behaves like a traditional SQL database management system. The remaining statements configure the database so that it uses a UTF-8 character encoding.

      If you want to use a case-insensitive collation instead of a case-sensitive one, change collation_server to utf8_unicode_ci.

   4. Copy the modified my.cnf to /etc by typing the following command:
   5. Open the System Preferences application, and in the Other section, click the MySQL icon.
   6. Stop the MySQL server, and then start it again for the changes to take effect.

Create a server instance

1. Download MySQL Workbench 5.2.
2. On the Home screen for the MySQL Workbench, in the Server Administration section, click New Server Instance.
3. Specify your root password by clicking Store In Keychain. Leave the remaining configuration values as they are.
4. On the Create the Instance Profile screen, type the server instance name (for example, pushsdk).

Create the database schema

1. On the Home screen for the MySQL Workbench, in the SQL Development section, double-click the database connection that you created when you created the server instance for the database.
2. Click the dummy database in the Schema section, and then right-click and choose Create Schema.
3. In the Name field, specify a name for the database schema (for example, pushsdk).
4. In the Default Collation drop-down list, click utf8_bin for a case-sensitive collation type, or utf8_unicode_ci for a case-insensitive collation type.
5. Click Apply twice.
6. Click Close.

Create a user account for the database schema

The user account that you set up in this task is the user account that you use to access the database tables through a Push Initiator.

1. On the Home screen for the MySQL Workbench, in the Server Administration section, double-click the server instance that you created.
2. From the Management panel on the left, click Users and Privileges.
3. Click Add Account at the bottom.
4. Click the Login tab, and specify a login name and password for the user.
5. In the Limit Connectivity to Hosts Matching field, type one or more names and host machines that the user can connect from (for example, localhost).
6. Click Apply.
7. On the Schema Privileges tab, in the Users column, click the user account you created.
8. Click Add Entry.
9. In the Host section, select the Selected host option.
10. In the Selected Host drop-down list, click the host machine that you want to define the privileges for (for example, localhost).
11. In the Schema section, select the Selected schema option.
12. In the Selected schema list, click the database schema that you created and that you want to define the privileges for.
13. Click OK.
14. Select the newly created entry in the list, and click Select 'ALL' to assign the user all privileges for this database schema.
15. Click Save Changes.

Create a new connection to the database schema

1. On the Home screen for the MySQL Workbench, in the SQL Development section, click New Connection.
2. In the Connection Name field, type a name for the connection.
3. In the Hostname field, type the name of the host machine that the server instance is installed on (for example, localhost).
4. In the Port field, type 3306.
5. In the Username field, type the name of the user that you created for the database schema.
6. In the Password field, click Store in Keychain .
7. Type the password of the user that you created for the database schema.
8. In the Default Schema field, type the name of the database schema that you created.
9. Click OK.