Install Phpmyadmin For Mac

Homebrew

In this tutorial we will learn to install Apache, MySQL, PHP on macOS Catalina 10.15. 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. Step 1 — Install or Restart Apache Web Sharing on Mac. To start Apache web sharing: sudo apachectl start. To stop the Apache service: sudo apachectl stop. To restart the Apache service.

When it comes to developing locally, there are many options for Mac users, including the dummy way of MAMP and XAMPP. However, for those who wants a NMP (Nginx, MySql, PHP) stack, it's not that simple. In this tutorial, I'll walk you through how to install these (plus the popular phpMyAdmin). The following has been tested on Snow Leopard and Mountain Lion.

To start with, we need to install Homebrew, a CLI tool that helps us install packages in a painless way. You can read more about Brew <a href='http://brew.sh/' target='_blank'>@ their official site</a>. Please note that MacPort is not compatible with Homebrew, if you have MacPort installed, uninstall it before installing Homebrew. To check if MacPort is installed, use which port

To install brew, open your Terminal and type

This will install brew nicely (note you need Ruby to do it, which comes pre-installed on most Mac). Before you install anything with Homebrew, use

to check if you are missing any dependencies or need to remove anything.

The next thing is to install MySql with

The output should be something like this

Then install default Nginx with

If you're looking to install Nginx with some additional modules, you might want to try the homebrew-nginx formula instead. Installation instructions are <a href='https://github.com/marcqualie/homebrew-nginx' target='_blank'>available here</a>

The output should be something like the following

And finally, let's install PHP. Because the PHP formula we want (<a href='https://github.com/josegonzalez/homebrew-php' target='_blank'>Github Repo Link</a>) doesn't come with default Homebrew installation, we can't just do a brew install php. First we need to tap a special channel to obtain the formula

This allows us to install PHP without Apache build and with FPM. For more options (like if you wanna install PHP 5.5 instead of 5.4), see <a href='https://github.com/josegonzalez/homebrew-php' target='_blank'>formula readme</a> for more information.

And last but not the least, we need to install phpMyAdmin. But before we do, we need to check for the $PHP_AUTOCONF variable. This is required for the phpMyAdmin installation process, or you will get the following error message

You can check for the value of $PHP_AUTOCONF by echoing it. The following is the path of my autoconf installation, yours may vary.

If you get only a blank line, you need to find out if autoconf is installed. If not, you can install it with brew install autoconf

Once you have the value, use an editor of choice to put the variable into your ~/.bash_profile configuration like so

Quit and start the terminal again and do another echo $PHP_AUTOCONF to confirm. Once you have that done, we're ready to install phpMyAdmin

And you should expect output like so

Configuration

Now that you have installed everything, time for configuring. All the following steps are optional

Start services when log in

Mac places the services that run at startup in a folder called ~/Library/LaunchAgents. If you wish to start these services at startup, you need to copy their individual .plist files from their directory to the LaunchAgents folder like so

Note: After copying them over, change ownership of all .plist files to that of root/admin to prevent any ownership issues.

As for starting and stopping a particular service, there are two options

• Use the executable. $ sudo /usr/local/Cellar/nginx/1.4.3/sbin/nginx -s reload
• Loading/Unloading the .plist $ sudo launchctl load homebrew.mxcl.nginx.plist

However, the .plist is not always accurate because it success silently and fails silently. If you're using the load/unload method, always check whether the process is running with

These information can all be found in the output during after installation. If you can't find them by some means, you can use

to get a list of directories related to the package.

PHP FPM

First let's cover some basic configuration. PHP FPM can run on a Unix socket or IP port, with the latter being the default. However, when you have multiple virtual hosts running on different ports, it's best not to use IP port in FPM configuration. Luckily, we can change that in the /usr/local/etc/php/5.4/php-fpm.conf.

Change the configuration from

to the following

and restart PHP-FPM

PHP Configuration

The php.ini governs how PHP behaves. In this tutorial, I'll only cover a best practice and configuring extensions.

In /usr/local/etc/php/5.4/php.ini, you will find the line

You should change the value to 0. The reason for doing so is outlined in <a href='https://www.digitalocean.com/community/articles/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu-12-04'>this post</a>

<blockquote>
If this number is kept as 1, the php interpreter will do its best to process the file that is as near to the requested file as possible. This is a possible security risk. If this number is set to 0, conversely, the interpreter will only process the exact file path—a much safer alternative.
</blockquote>

Nginx Configuration

Configuration files for Nginx is different from its installation directory. On both Snow Leopard and Mountain Lion, the Nginx configuration files are located in

First we would need to create 3 directories

• conf.d holds commonly used configuration
• sites-enabled holds all virtual host configuration
• logs for all log files

Then we are going to edit the nginx.conf to the following

Before setting up virtual host, first let's set up PHP-FPM configuration. Create a file called php in conf.d directory and place the following content

Then in the sites-enabled directory, create a file called pma and place the following content

Test your configuration with

If successful, you can restart your Nginx configuration with

Note: remember to create the host in /etc/hosts and the log files specified.

Fire up your browser, point it to http://pma.host/ and you're ready to Rock n' Roll! (Psssst, the default login for MySQL is root/root)

<a href='http://angelawang.me/wp-content/uploads/Screen-shot-2013-10-19-at-3.32.47-PM.png'></a>

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

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.

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.

Download Ancient Rome 2 Free for macOS 10.6.6 or later and enjoy it on your Mac. ‎Construct entire residential districts for people and improve their well-being by building markets, schools, theaters and other places, and connect them with roads for ease of access. Scarica Ancient Rome 2 per macOS 10.6.6 o versione successiva e comincia a usarlo sul tuo Mac. ‎Construct entire residential districts for people and improve their well-being by building markets, schools, theaters and other places, and connect them with roads for ease of access. You may want to check out more Mac applications, such as Ancient Rome 2 Free, Cradle of Rome Free or Cradle of Rome, which might be related to Ancient Rome 2. Comments You can also add comment via Facebook. Choose between 3486 ancient rome icons in both vector SVG and PNG format. Related icons include history icons, landmark icons, building icons, egypt icons Download all the ancient rome icons you need. Ancient Rome 2 for Mac. Ancient Rome 2 for Mac. Free to try Macgamestore Mac OS X 10.5/Intel Version 1.0 Full Specs. Download Now Secure Download. Publisher's Description. From Macgamestore. Ancient rome icons ii for mac.

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. Geometry dash download macbook pro.

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.

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

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.