How to install and configure Apache, MySQL and PHP on Mac OS X 10.7 Lion and OS X 10.6 Snow Leopard.

1. Download Phpstorm
2. Phpstudy Macos
3. Phpstudy Mac版

OSX 10.8 Mountain Lion VersionOSX 10.9 Mavericks Version
Apache and PHP already come preloaded in OS X 10.7 Lion and 10.6 Snow Leopard, the versions on 10.7 Lion are PHP 5.3.6 and Apache 2.2.20, these 2 pieces of Open Source software are part of the “AMP” stack with MySQL the missing third component.

PhpStudy 小皮面板服务器环境配置解决方案官方免费版，PhpStudy 可以帮助在本地配置服务器运行环境是一款学习建站，网站修改测试必备的本地服务器环境配置解决方案，支持ssl证书配置，php多版本共存，FTP管理，redis等，一键LAMP,LNMP,集群,监控,网站,FTP,数据库,JAVA等100多项服务器管理功能。. If you just want to try phpMyAdmin in a virtual machine, you might want to check the available software appliances which provide phpMyAdmin. If you do not find a suitable package or wish to install your. PhpStudy for Linux 支持Apache/Nginx/Tengine/Lighttpd，支持php5.2/5.3/5.4/5.5切换，可以自由切换php的版本。. This function is an alias of: mysqli::construct Although the mysqli::construct documentation also includes procedural examples that use the mysqliconnect function, here is a short example. PhpDesigner 8 is a fast PHP IDE and PHP editor with built-in HTML5-, CSS3- and JavaScript editors boosted with features to help you create amazing websites. PhpDesigner 8 helps you with all from.

Their are other options for Mac users to install an AMP stack using prebuilt point and click downloads including the following, MAMP, DAMP, XAMPP and BitNami – these installations use separate binaries outside of the regular OS X software so no conflict occurs and it makes it easier to delete the stacks without affecting other parts of the operating system.

However sometimes you need to configure these with different port numbers and this can lead to issues and there is the question of vendor support and application versions.

This tutorial bypasses the 3rd party AMP stacks and uses the native installed components with the exception of MySQL which is a separate install, unless you have OS X Server, which then MySQL comes preloaded in 10.6 but not 10.7 which has dumped MySQL in favour of PostgreSQL instead – you can still install MySQL on 10.7 Server with the instructions below.

To get Apache, MySQL and PHP running natively on OSX is quite easy and straightforward – this guide should have you up and running in no time.

This guide uses the command line to achieve some text editing of various configuration files, however If you aren’t comfortable in the Terminal you can do this in a graphical mode, download a free text editor utility call TextWrangler, launch it, when you come to edit one of the configuration files, open file, you have to click on “show hidden items” at the bottom of the open dialog box to see all of the system files. But you will still need to use the terminal for some of the commands which don’t involve editing files.

PHP

You can verify your version of PHP by launching the Terminal application, as found in the Utilities folder: /Applications/Utilities/Terminal

To find the PHP version, type at the prompt:

And the version is displayed:

To find the Apache version, type at the prompt:

And the version is displayed:

So far so good, however by default PHP is not enabled and has to have its module loaded you need to make a simple edit in the Apache configuration file “httpd.conf” file. This is filed in /etc/apache2/httpd.conf, get there in the terminal by typing:

Then in the terminal you need to use a text editor either “vi” or nano” will do, this file also has stricter permissions so the “sudo” command needs to be used to edit the file, you will need to be an admin user to have permission to change the file, type:

and then your password.

Once in nano click “control+w” to get a search dialog, type “php” and this will bring you to the php module line:

Uncomment out the hash # to leave it like:

enable php module in nano

Finally type “control + x” to exit and when prompted save the change by typing “y”

MySQL

So now onto the 2nd piece of the puzzle, MySQL. You need to download it from http://dev.mysql.com/downloads/mysql/, chose Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive for an Intel Mac the .dmg file is a point and click installation nice and easy, you can download the tar.gz also for a command line install. The easiest format is the .dmg file as it allows for an installation visually using the GUI.

When downloading you don’t have to sign up, look for » No thanks, just take me to the downloads! – go straight to the download mirrors and download the software from a mirror which is closest to you.

After download open the .dmg and install:

• mysql5.6.xxx.pkg
• MySQLstartupitem.pkg
• MySQLPrefPane

The first is the MySQL software, the 2nd item allows MySQL to start when the Mac is booted and the third is a System Preference that allows start/stop operation and a preference to enable it to start on boot.

Installation of MySQL

Once the installs are done you can start the mysql server right from the System Preferences which has a new preference in the “Other” category called “MySQL” click start and now it is running.

mysql-system-preference-osx

To find the MySQL version from the terminal, type at the prompt:

This also puts you in to an interactive dialogue with mySQL, type q to exit.

If you got the error:

then mysql was not started, go back to the System Preference and start the database.

After installation, in order to use mysql commands without typing the full path to the commands you need to add the mysql directory to your shell path, this is done in your “.bash_profile” file in your home directory, if you don’t have that file just create it using vi or nano:

and then add:

The first command brings you to your home directory and opens the .bash_profile file or creates a new one if it doesn’t exist, then add in the line above which adds the mysql binary path to commands that you can run. Exit the file with type “control + x” and when prompted save the change by typing “y”. Last thing to do here is to reload the shell for the above to work straight away.

Then test the path by just this time issuing the mysql command without the full path:

You will get the version number again, just type “q” to exit.

The next step is to set up a root password for mysql there are 2 ways to do this one is a regular way and the other provides additional security and disables all other access:

Regular Way

If you have set the path correctly as above:

!use the single quotes

Then when logging in to mysql:

!NB the no space between -p and the password

Securer Way

Go ahead and just hit enter if this is a new installation and no password currently exists, follow the prompts to set up a new root password – this is a root password just for mysql separate from the root password of OS X you should set this.

You also get asked about:

• Removing anonymous users?
• Disallow root login remotely?
• Remove test database and access to it?
• Reload privilege tables now?

If this is a new installation you can just answer yes to the questions.

Once the root user and password is set, you have to interact with mysql with the username and password, so access via command line is (note that there is no space between -p and the password):

So thats the two components installed with MySQL having a System Preference option to Start/Stop the database.

Apache

You can start/stop the Web Server Apache in the System Preferences under Sharing and checking the WebSharing box. (Sometimes you may have to toggle it on/off a few times to get it going).

web-sharing-turned-on

This can also be accomplished in the terminal using:

Or restart the web server gracefully using the following:

Once you start your server the there are 2 x document root folders for sharing, one is a top level and the other is user account specific:

and

You should see a “It Works!” or a OSX welcome page depending on which document root you are at, in the finder these locations are found at your Sites folder in your home folder for local user:
/Users/username/Sites/

or at the higher level

/Library/WebServer/Documents/

At the user level in Lion 10.7 you may need to create the personal web sharing folder first, do this through System Preferences > Sharing > Web Sharing and click “Create Personal Website Folder” if it is created this will say ” Open Personal WebSite Folder”

The final thing to verify is that PHP is loaded and ready to go by creating a new text file, has to be plain text (use TextEdit) and typing in:

Save the file as phpinfo.php and save it to the Sites folder in your home directory. Now point your browser to:

You should see the full PHP configuration page. If you just see the code restart the web server to make sure the php module is loaded.

php-module-configuration

That’s it you are ready to develop and share!

The only difference between 10.6 and 10.7 are some incremental version numbers on Apache and MySQL otherwise the process is the same for both operating systems.

To get up and running with mysql and use phpMyAdmin to manage the mysql database, there is a guide here.

Then look at installing WordPress, Drupal and Joomla!!!

Download

Many operating systems already include a phpMyAdmin package and will automatically keep it updated, however these versions are sometimes slightly outdated and therefore may be missing the latest features. Additionally, the configuration process varies widely by package and may not adhere to the official phpMyAdmin documentation. That being said, it is usually the quickest and easiest way of keeping an updated installation. Please contact your OS vendor for more information. Some additional information is also available in our documentation. If you just want to try phpMyAdmin in a virtual machine, you might want to check the available software appliances which provide phpMyAdmin.

If you do not find a suitable package or wish to install your own phpMyAdmin, you can download one of the following kits. Please note that each version has requirements for the minimum PHP and MySQL versions.

Since July 2015 all phpMyAdmin releases are cryptographically signed by thereleasing developer. You should verify that the signature matches the archiveyou have downloaded. Verification instructions are placed in ourdocumentation in the Verifying phpMyAdmin releases chapter.

phpMyAdmin 4.9.7

Released 2020-10-15, see release notes for details.

Older version compatible with PHP 5.5 to 7.4 and MySQL 5.5 and newer. Currently supported for security fixes only.

phpMyAdmin 5.0.4

Released 2020-10-15, see release notes for details.

Current version compatible with PHP 7.1 and newer and MySQL 5.5 and newer.

Development Versions

phpMyAdmin Git repository is located athttps://github.com/phpmyadmin/phpmyadmin.git and youcan browse them online using GitHub.Note that phpMyAdmin uses Composer to manage library dependencies, when using gitdevelopment versions you must manually run Composer.Please see the documentation for details.

More information about using Git is available on development page.

phpMyAdmin 5.1+snapshot

Daily snapshot, generated 2020-12-08, from Git commit f018156de33517212c636f6991dac69a8eac9c8f.

Future version compatible with PHP 7.1 and newer and MySQL 5.5 and newer.

phpMyAdmin 5.0+snapshot

Daily snapshot, generated 2020-12-08, from Git commit e7693597cd9a59c11c7f93a4960dc6cdcd65b5b4.

Current version compatible with PHP 7.1 and newer and MySQL 5.5 and newer.

phpMyAdmin 4.9+snapshot

Daily snapshot, generated 2020-12-08, from Git commit e7c5d43080270d93bfd2d52f2fc8a7e5e32b1371.

Older version compatible with PHP 5.5 to 7.4 and MySQL 5.5 and newer. Currently supported for security fixes only.

Download Phpstorm

Latest Stable Version

You can also directly download latest version on following URLs:

We also publish a variety of formats intended for parsing by scripts to download the latest version. Read more about those on our syndication page.

Older Releases

You can find older releases on separate files page. You can also get them from our Git repository (check developer information for instructions). Older releases are unsupported.

Installing phpMyAdmin

The full process of installing phpMyAdmin is described in our manual. You can also find information there about how to install phpMyAdmin on your Linux distribution.

Official Docker image

The phpMyAdmin team maintains an official Docker image for phpMyAdmin. It is fully documented in our manual and you can install it using:

Installing using Composer

Due to technical limitations, we're currently unable to publish phpMyAdmin directly in Packagist repository, but it is possible to install phpMyAdmin from our own Composer repository. Please check our manual for more information.

Appliances

Software appliances are becoming a popular way of distributing software. They are distributed as an image, which can be directly used by system (be it ISO image for bootable CD or virtual disks for some type of virtualization).

There are quite many appliances which provide phpMyAdmin as a management tool for MySQL. It usually comes as part of LAMP stack but there might be other offerings as well. Please check your favorite appliance provider, ISV or app store for it. Some of the appliances are listed on Wikipedia.

Supported versions

Phpstudy Macos

Generally only last stable branch is supported, but there are LTS branches to support older PHP versions. Current stable branch is supported for bug fixes, LTS branches for security fixes only.

Phpstudy Mac版