- Install Mysql Mac Catalina
- Mysql Workbench Mac Catalina
- Restart Mysql Mac Catalina
- Start Mysql Mac Catalina
After download XAMPP mac os version, double click it to install it. After install, you can start it by click XAMPP icon in finder /Applications folder. After click XAMPP icon, it will display below popup window. Click Start button to start both apache, mysql and ftp server as service. Click Stop button to stop it. Mac Os Catalina Mysql Posted on by admin The professional data recovery software for Mac can recover deleted files even if they have been permanently removed or emptied from Trash or Bin.
In this tutorial we will learn to install Apache, MySQL, PHP on macOS Mojave 10.14.
macOS Mojave
Ahnlab inc. Apple released the new macOS Mojave 10.14 on 24th September 2018 and it includes Apache and PHP.
We will be using the pre-installed Apache and PHP and we will download and setup MySQL database.
Lets go ahead and configure our LAMP stack development environment on macOS Mojave.
Apache
The new macOS Mojave 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.
macOS Mojave comes with Apache/2.4.34.
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.
Install Mysql Mac Catalina
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.
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 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 Mojave is located in the following directory.
User level document root
For the user level we can create a directory called Sites in user directory.
Creating Sites directory
Run the following command to switch to the user home directory.
Now, run the following command to create the Sites directory.
For me the user document root path is the following.
Creating username.conf file
Now, its time to create a username.conf file which will help in configuring 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. How to backup borderlands 2 exe.
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. Now, type the following inside 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, to come out of the INSERT mode press the Esc key. And to save the file and exit type the following :wq and hit Enter.
The permission of this file should be the following.
If not, then use the following command to change its permission.
Where, username is your username that you have set earlier.
Configuring the httpd.conf file
Type the following command in the terminal and go to apache2 directory.
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 in the terminal.
Now open the httpd.conf file using vi and uncomment the following lines.
To uncomment the following 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, we will make some changes in the httpd-userdir.conf file.
Type the following command in the terminal to go to the extra directory.
As a good practice we will first create a backup copy of the httpd-userdir.conf file. Type the following command to create a backup copy.
Now open the file using vi.
Uncomment the following line.
Now check that everything is configured properly by typing the following command in the terminal.
And then restart Apache using the following command.
PHP
macOS Mojave comes with PHP 7.1.x pre-installed.
To check the version of PHP in the Terminal type the following command.
Alright, type the following command in the terminal to go to apache2 directory.
Open the httpd.conf file.
Enter into INSERT mode by pressing the i key 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 by running the following command.
Now open this 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
Mysql Workbench Mac Catalina
Head over to mysql.com website and download the latest version of the MySQL Community Server.
Restart Mysql Mac Catalina
Download and run the installer and follow the steps to install MySQL database on your Mac.
Start Mysql Mac Catalina
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.