Mac OS X Snow Leopard 开启Web共享，建立Web服务器:Apache+PHP+MySql

来源：互联网发布：淘宝小号批量购买编辑：程序博客网时间：2024/06/05 23:12

1.开启Web Sharing:

System Preferences -> Sharing -> 勾选Web Sharing

网站默认目录位于 ~/Sites

测试：http://localhost/~ElfSundae （ElfSundae为你的用户名）

2.配置Apache，安装并配置MySql

详见：

Install Apache/PHP/MySQL on Mac Snow Leopard

http://www.cnblogs.com/elfsundae/archive/2010/11/27/1889570.html

注意：该篇文章是我转载国外的一篇文章，是stackoverflow热烈讨论后的精华，建议详细阅读并熟记。

安装完MySql后在系统预设里Start MySql Server

如果需要更改默认端口80，最简便的方法就是显示隐藏文件，直接编辑 /private/etc/apache2/httpd.conf

为MySql添加环境变量PATH：

不会添加PATH的请移步：http://www.cnblogs.com/elfsundae/archive/2010/12/01/1893190.html

/*引用MySql ReadMe*/

The Mac OS X PKG of MySQL installs itself into
`/usr/local/mysql-VERSION' and also installs a symbolic link,
`/usr/local/mysql', that points to the new location. If a directory
named `/usr/local/mysql' exists, it is renamed to
`/usr/local/mysql.bak' first. Additionally, the installer creates the
grant tables in the `mysql' database by executing `mysql_install_db'.

$ echo 'export PATH=/usr/local/mysql-5.1.53-osx10.6-x86/bin:$PATH' >> ~/.bash_profile

测试PATH：$ mysql --version
mysql Ver 14.14 Distrib 5.1.53, for apple-darwin10.3.0 (i386) using readline 5.1

建立管理员帐号：帐号：root,密码：123456

$ mysqladmin -u root password 123456
$ mysql -uroot -p123456
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.53 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye

3.测试PHP

在/Library/WebServer/Documents 下建立test.php：

<html>
<head>
<title> php test - By:Elf Sundae </title>
</head>

<body>
<?php
echo "http://www.cnBlogs.com/ElfSundae <hr>";

phpinfo();
?>

</body>
</html>

测试:http://localhost:8080/test.php （如果你没有改默认端口，就不需要加:8080)

如果上边操作都正确，但该链接不可以用提示无法连接到localhost ，则重新启动Apache 就可以了

4.测试MySql连接

建表：

mysql> Create database mytest;
Query OK, 1 row affected (0.00 sec)

mysql> use mytest;
Database changed
mysql> CREATE TABLE members (
    -> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> password VARCHAR(12) NOT NULL,
    -> username VARCHAR(12) NOT NULL,
    -> index(password),
    -> index(username));
Query OK, 0 rows affected (0.06 sec)

mysql> insert into members values('','ElfSundae','abcdef');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>

更改刚才创建的test.php为以下内容：

<html>
<head>
<title> php mysql test - By:Elf Sundae </title>
</head>

<body>
<?php
echo "http://www.cnBlogs.com/ElfSundae <hr>";

$link = mysql_connect("localhost","root","123456") or die("Unable to connect to SQL server");
mysql_select_db("mytest",$link) or die("Unable to select database");


$qstr = "SELECT * from members where id = '1' ";
$result = mysql_query($qstr); 

if (mysql_num_rows($result))  
{
 $username = mysql_result($result,0, "username");
 $password = mysql_result($result,0, "password");
 echo "<b>The username:</b> $username<br>";
 echo "<b>The password:</b> $password<br>";
}
else echo "ERROR - unable to find username and password!";

mysql_close(); 

?>

</body>
</html>