分离php和mysql搭建lamp平台

《分离php和mysql搭建lamp平台》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、分离php和mysql搭建LAMP平台正常情况下，同一台服务器上搭建LAMP平台各组件安装顺序：Linux-mysql-apache-php。其中，mysql和apache安装没有前后顺序。下面针对mysql和apache+php不在同一服务器，如何实现php连接到Mysql一、安装mysql服务器（192.168.10.2）a)创建mysql运行用户Useradd-M-u30-s/sbin/nologinmysql(这里用户必须是mysql)b)解码mysql源码包Tarzxfmysql-5.1.55.tar.gz-C/usr/src/c)配置并

2、制定安装路径./configure--prefix=/usr/local/mysql--with-charset=utf8--with-collation=utf8_general_ci--with-extra-charsets=gbk,gb2312d)修改include子文件夹下的config.h文件，实现完美支持gbk,gb2312字符集编码Viminclude/config,h#defineHAVE_CHARSET_GBK1#defineHAVE_CHARSET_GB23121E)编译安装make&&makeinstallF)建立my.cnf

3、配置文件cpsupport-files/my-medium.cnf/etc/my.cnfG)初始化数据库文件，授予Mysql用户运行权限/usr/local/mysql/bin/mysql_install_db--user=mysqlChown-Rroot:mysql/usr/local/mysqlChown-Rmysql/usr/local/mysql/var/H)优化路径Ln-s/usr/local/mysql/bin/*/usr/local/binLn-s/usr/local/mysql/lib/mysql/*/usr/lib/Ln-s/us

4、r/local/mysql/include/mysql/*/usr/includeI)添加系统服务cp/usr/src/mysql-5.1.55/support-fils/mysql.server/etc/init.d/mysqldchmoda+x/etc/init.d/mysqldchkconfig--addmysqld启动mysql服务J)授权mysql管理员远程登录mysql数据库Updatemysql.usersethost=’192.168.10.1’wherehost=’127.0.0.1’;Flushprivileges;二、apac

5、he+php安装（192.168.10.1）a)Apache安装i.卸载rpm包安装的httpd服务1.Rpm-ehttpd[--nodeps]ii.解包1.Tarzxfhttpd-2.2.17-tar.gz/usr/srciii.配置1../configure--prefix=/usr/local/httpd--enable-so--enable-rewrite--enable-charset-lite--enable-cgiiv.编译安装1.Make&&makeinstallv.优化路径1.Ln-s/usr/local/httpd/bin/*/

6、usr/local/bin/vi.添加系统服务1.Cp/usr/local/httpd/bin/apachectl/etc/init.d/httpd2.Vim/etc/init.d/httpda)#chkconfig:358515b)#description:sdfljsdljflsadjfljd!!c)Chkconfig--addhttpdd)/etc/init.d/httpdstartb)PHP安装1、安装数据加密等扩展工具（libmcryptmhashmcrypt）注意：mcrypt包最后装需要的路径优化：Ln-s/usr/local/lib

7、/libmcrypt*/usr/libLn-s/usr/local/lib/libmhash.*/usr/lib1、编译安装PHPa)Tarzxfphp-5.3.6.tar.gz-C/usr/src/b)Cd/usr/src/php-5.3.6/c)./configure--prefix=/usr/local/php5-with-mcrypt--with-apxs2=/usr/local/httpd/bin/apxs-with-config-file-path=/usr/loca/php5--enable-mbstringd)Make&&makei

8、nstall3、建立php.ini配置文件并调整内容Cpphp.ini.development/usr/local/php