mac10.10配置apache环境

来源：互联网发布：mac可以玩使命召唤吗编辑：程序博客网时间：2024/06/15 17:36

sudo apachectl -v

1 apache配置

sudo vi /etc/apache2/httpd.conf
#Include /private/etc/apache2/extra/httpd-vhosts.conf 去掉注释

sudo vi /etc/apache2/extra/httpd-vhosts.conf
<VirtualHost *:80>
DocumentRoot "/Users/xxx/work_dev/mysite"
ServerName localhost
ErrorLog "/private/var/log/apache2/mysite-error_log"
CustomLog "/private/var/log/apache2/mysite-access_log" common
<Directory />
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Require all granted
</Directory>
</VirtualHost>

sudo apachectl restart

http://localhost/

2 php配置

cd /etc/apache2/
sudo vi httpd.conf
#LoadModule php5_module libexec/apache2/libphp5.so 去掉注释

cd /etc
sudo cp php.ini.default php.ini
sudo apachectl restart

cd /Users/xxx/work_dev/mysite
vi info.php
<html><body><h1>It works!</h1><?php phpinfo(); ?></body></html>

http://localhost/info.php

3 mysql安装
安装后在系统偏好设置里启动mysql

sudo chmod +w bashrc

sudo vi /etc/bashrc
alias mysql='/usr/local/mysql/bin/mysql'
alias mysqladmin='/usr/local/mysql/bin/mysqladmin'
重新启动终端

mysqladmin -u root password "123"
mysqladmin -u root -p password "123"

4 PHPAdmin配置

下载PHPAdmin，解压到/Users/xxx/work_dev/mysite目录，重命名为phpmyadmin

http://localhost/phpmyadmin/setup/

5 mysql命令

设置数据库默认字符集
mysql -u root -p
create database mydb;
alter database mydb default character set = utf8;
mysql默认使用的字符集是latin1

查看当前使用的数据库:
mysql>select database();
mysql>status;
mysql>show tables;
mysql>show databases;//可以查看有哪些数据库,返回数据库名
mysql>use databaseName;//更换当前使用的数据库
mysql>show tables;//返回当前数据库下的所有表的名称
或者也可以直接用以下命令
mysql>show tables from databaseName;

mysql查看表结构命令，如下:
desc 表名;
show columns from 表名;
或者
describe 表名;
show create table 表名;
或者
use information_schema
select * from columns where table_name='表名';

查看警告：
mysql> show warnings;

php写文件失败时：
chmod 777 upload

php连接mysql时no such file or dir问题解决：
sudo mkdir /var/mysql
sudo ln -s /private/tmp/mysql.sock /var/mysql/mysql.sock
ls -l /var/mysql
total 8
lrwxr-xr-x 1 root wheel 23 12 16 17:02 mysql.sock -> /private/tmp/mysql.sock

0 0