Configuring Apache + PHP + MySQL in Mac OS X 10.8
Jul 09, 2016 am 09:09 AMConfiguring Apache+PHP+MySQL in Mac OS X 10.8 includes:
- Configuring Apache
- Configure PHP
- Install MySQL
- Configure PHPAdmin
- Set database default character set
1. Configure Apache
1. Start Apache
Open the terminal and enter:
sudo apachectl start
Open the browser and enter:
http://localhost
You should see the "It works!" page, which is located in the /Library/WebServer/Documents/ directory, which is the default root directory of Apache.
2. Configure user access directory
In the terminal enter:
mkdir ~/Sites cp /Library/WebServer/Documents/index.html.en index.html
Create a new directory named Sites in the user directory as the access path to the user directory, and copy /Library/WebServer/Documents/index.html to the user directory
Enter:
<span style="color: #000000;">cd /etc/apache2/users/ sudo vi apple.conf</span>
Note: apple is your username.
In vi, press i to start typing and enter the following:
<Directory "/Users/apple/Sites/"> Options Indexes MultiViews AllowOverride All Order allow,deny Allow from all </Directory>
After completing the input, press the ESC key, then enter: wq, save and close vi.
Note: The first line of the file is used to specify the location of the user directory, where apple is your username.
In the terminal enter:
sudo apachectl restart
Restart Apache and now you can access it in the browser:
http://localhost/~apple
2. Configure PHP
In the terminal enter:
cd /etc/apache2/ sudo vi httpd.conf
In vi, enter /php to search for text containing php and find:
#LoadModule php5_module libexec/apache2/libphp5.so
Delete the # in front, then save and exit. (Press shift i to enter at the beginning of the line, press ESC to exit editing, press x to delete the current character, and #, enter: wq, save and exit.)
Enter in the terminal:
cd /etc sudo cp php.ini.default php.ini sudo apachectl restart
Enter in the terminal:
cd ~/Sites vi info.php
Then enter the following into info.php:
<span style="color: #0000ff;"><</span><span style="color: #800000;">html</span><span style="color: #0000ff;">><</span><span style="color: #800000;">body</span><span style="color: #0000ff;">><</span><span style="color: #800000;">h1</span><span style="color: #0000ff;">></span>It works!<span style="color: #0000ff;"></</span><span style="color: #800000;">h1</span><span style="color: #0000ff;">></span><span style="color: #0000ff;"><?</span><span style="color: #ff00ff;">php phpinfo(); </span><span style="color: #0000ff;">?></span><span style="color: #0000ff;"></</span><span style="color: #800000;">body</span><span style="color: #0000ff;">></</span><span style="color: #800000;">html</span><span style="color: #0000ff;">></span>
Enter in the browser:
http://localhost/~apple/info.php
3. Install Mysql
1. Download mysql-5.6.12-osx10.7-x86_64.dmg from the Mysql official website and double-click to open the dmg file.
2. Run mysql-5.6.12-osx10.7-x86_64.pkg to install the main package;
3. Run MySQLStartupItem.pkg to let mysql run automatically at boot;
4. Run MySQL.prefPane and add the mysql service management option in the system preferences;
Enter in the terminal:
<span style="color: #0000ff;">sudo</span> <span style="color: #0000ff;">chmod</span> +<span style="color: #0000ff;">w</span><span style="color: #000000;"> bashrc </span><span style="color: #0000ff;">sudo</span> <span style="color: #0000ff;">vi</span> /etc/bashrc
Add the following two command aliases at the end of bashrc to facilitate quick use of mysql
#mysql alias mysql='/usr/local/mysql/bin/mysql' alias mysqladmin='/usr/local/mysql/bin/mysqladmin'
Tip: After adding the command alias in bashrc, you need to restart the terminal.
Change the default password of mysql and enter in the terminal:
mysqladmin -u root password "123"
You can specify any password at position 123.
If you want to change your password, you can enter
mysqladmin -u root -p password "123"
Before changing the password, you need to enter the previous correct password.
4. Configure PHPAdmin
1. Download PHPAdmin, extract it to the ~/Sites directory, and rename the directory to: phpmyadmin;
2. Enter in the browser:
http://localhost/~apple/phpmyadmin/setup/
Just add a server configuration.
5. Set the database default character set
Enter in the terminal:
mysql -u root -p # 創(chuàng)建名為 mydb 的數據庫 create database mydb; # 將 mydb 的默認字符集設置為 utf8 alter database mydb default character set = utf8;
Note: The default character set used by mysql is latin1, which does not support Chinese and needs to be set.
Get it done and call it a day :)
P.S.
There are many documents on the Internet about configuring php mysql on mac. This article only focuses on my usage needs and simply records the steps. :)

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)

ToaccessenvironmentvariablesinPHP,usegetenv()orthe$_ENVsuperglobal.1.getenv('VAR_NAME')retrievesaspecificvariable.2.$_ENV['VAR_NAME']accessesvariablesifvariables_orderinphp.iniincludes"E".SetvariablesviaCLIwithVAR=valuephpscript.php,inApach

PHPhasthreecommentstyles://,#forsingle-lineand/.../formulti-line.Usecommentstoexplainwhycodeexists,notwhatitdoes.MarkTODO/FIXMEitemsanddisablecodetemporarilyduringdebugging.Avoidover-commentingsimplelogic.Writeconcise,grammaticallycorrectcommentsandu

When using PHP preprocessing statements to execute queries with IN clauses, 1. Dynamically generate placeholders according to the length of the array; 2. When using PDO, you can directly pass in the array, and use array_values to ensure continuous indexes; 3. When using mysqli, you need to construct type strings and bind parameters, pay attention to the way of expanding the array and version compatibility; 4. Avoid splicing SQL, processing empty arrays, and ensuring data types match. The specific method is: first use implode and array_fill to generate placeholders, and then bind parameters according to the extended characteristics to safely execute IN queries.

There are three key ways to avoid the "undefinedindex" error: First, use isset() to check whether the array key exists and ensure that the value is not null, which is suitable for most common scenarios; second, use array_key_exists() to only determine whether the key exists, which is suitable for situations where the key does not exist and the value is null; finally, use the empty merge operator?? (PHP7) to concisely set the default value, which is recommended for modern PHP projects, and pay attention to the spelling of form field names, use extract() carefully, and check the array is not empty before traversing to further avoid risks.

WhensettingupMySQLtables,choosingtherightdatatypesiscrucialforefficiencyandscalability.1)Understandthedataeachcolumnwillstore—numbers,text,dates,orflags—andchooseaccordingly.2)UseCHARforfixed-lengthdatalikecountrycodesandVARCHARforvariable-lengthdata

In PHP, you can use a variety of methods to determine whether a string starts with a specific string: 1. Use strncmp() to compare the first n characters. If 0 is returned, the beginning matches and is not case sensitive; 2. Use strpos() to check whether the substring position is 0, which is case sensitive. Stripos() can be used instead to achieve case insensitive; 3. You can encapsulate the startsWith() or str_starts_with() function to improve reusability; in addition, it is necessary to note that empty strings return true by default, encoding compatibility and performance differences, strncmp() is usually more efficient.

The key steps to install PHP on Windows include: 1. Download the appropriate PHP version and decompress it. It is recommended to use ThreadSafe version with Apache or NonThreadSafe version with Nginx; 2. Configure the php.ini file and rename php.ini-development or php.ini-production to php.ini; 3. Add the PHP path to the system environment variable Path for command line use; 4. Test whether PHP is installed successfully, execute php-v through the command line and run the built-in server to test the parsing capabilities; 5. If you use Apache, you need to configure P in httpd.conf
