-DWITH_READLINE=1 支持readline库
-DENABLED_LOCAL_INFILE=1 启用加载本地数据
-DMYSQL_USER=mysql 指定mysql运行用户
-DMYSQL_TCP_PORT=3306 指定mysql端口
make
make install
make clean
rm CMakeCache.txt
#如果报错，清除缓存，请使用以上命令
cd /usr/local/mysql/
chown -R mysql .
chgrp-R mysql .
#修改mysql目录权限
/usr/local/mysql/scripts/mysql_install_db--user=mysql
#创建数据库授权表，初始化数据库
chown-R root .
chown -R mysql data
#修改mysql目录权限
cpsupport-files/my-medium.cnf /etc/my.cnf
#复制mysql配置文件
/usr/local/mysql/scripts/mysql_install_db--user=mysql
启动MySQL服务：
1.用原本源代码的方式去使用和启动mysql
/usr/local/mysql/bin/mysqld_safe--user=mysql &
&符号后台运行
2.重启以后还要生效:
vi/etc/rc.local
/usr/local/mysql/bin/mysqld_safe--user=mysql &
3.设定mysql密码
/usr/local/mysql/bin/mysqladmin-uroot password lonly
清空历史命令 history -c
* 给mysql用户root加密码123
* 注意密码不能写成 “123”
/usr/local/mysql/bin/mysql -u root -p
mysql>showdatabases;
mysql>usetest;
mysql>showtables;
mysql>s #查看字符集是否改为utf8
* 进入mysql以后用set来改密码
mysql> exit
* 登录MySQL客户端控制台设置指定root密码
# 安装PHP
编译前确保系统已经安装了libtool和libtool-ltdl软件包，安装：
yum -y install “libtool*”
yum -y install “libtool-ltdl*”
vi /usr/local/gd2/include/gd_io.h
typedef struct gdIOCtx
{
……
void(*data);
#加入此句
}
#php 5.4 的bug，检测gd库有问题，需要手工修改
cd/lamp/ php-5.4.25
./configure--prefix=/usr/local/php/ --with-config-file-path=/usr/local/php/etc/--with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/local/mysql/--with-libxml-dir=/usr/local/libxml2/ --with-jpeg-dir=/usr/local/jpeg6/--with-png-dir=/usr/local/libpng/ --with-freetype-dir=/usr/local/freetype/--with-gd=/usr/local/gd2/ --with-mcrypt=/usr/local/libmcrypt/ --with-mysqli=/usr/local/mysql/bin/mysql_config--enable-soap --enable-mbstring=all --enable-sockets --without-pear
