mac lion 安装 mysql_Mac OS Lion 下编译安装Nginx + PHP + Mysql

Mac OS Lion 下编译安装Nginx 1.0.12 + PHP 5.3.10 + Mysql 5.5.18 + Xdebug + PHPUnit

mysql编译安装:

1. 建立mysql数据存储目录, 权限设置为mac os默认存在的_mysql权限：

mkdir -p /var/mysql/data/

chown -R _mysql:_mysql /var/mysql/

2. 下载mysql， 我下的版本为mysql-5.5.18， 执行以下跨平台编译命令：

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/server/mysql -DMYSQL_DATADIR=/var/mysql/data -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DSYSCONFDIR=/etc/ -DWITH_SSL=yes -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=on

3. 编译， 安装：

make

sudo make install

4. 改变mysql目录的权限：

sudo chmod +w /usr/local/server/mysql

sudo chown -R _mysql:_mysql /usr/local/server/mysql

5. 创建库软链接：

sudo ln -s /usr/local/server/mysql/lib/lib* /usr/lib/

6. copy配置文件到etc目录：

cp /usr/local/server/mysql/support-files/my-large.cnf /etc/my.cnf

[client]

default-character-set = utf8

[mysqld]

character-set-server = utf8

default-storage-engine = MyISAM

basedir = /usr/local/server/mysql

datadir = /var/mysql/data

log-error = /var/mysql/mysql_error.log

pid-file = /var/mysql/mysql.pid

7. 建立初始数据表：

sudo /usr/local/server/mysql/scripts/mysql_install_db –basedir=/usr/local/server/mysql –datadir=/var/mysql/data –user=_mysql

8. 设置root密码:

sudo /usr/local/server/mysql/bin/mysqladmin -u root password ‘mysql’

9.启动mysql:

sudo /usr/local/server/mysql/bin/mysqld_safe –user=_mysql &

10. 测试安装是否成功：

/usr/local/server/mysql/bin/mysql -u root -p -S /tmp/mysql.sock