一,安装MYSQL
1,添加mysql组
groupadd mysql
2,添加mysql用户
useradd mysql -g mysql -M -s /sbin/nologin (-M:不创建家目录 -s:不允许登录)
3,配置mysql-5.1.72
./configure \
--prefix=/application/mysql5.1.72 \
--with-unix-socket-path=/application/mysql5.1.72/tmp/mysql.sock \
--localstatedir=/application/mysql5.1.72/data \
--enable-assembler \
--enable-thread-safe-client \
--with-mysqld-user=mysql \
--with-big-tables \
--without-debug \
--with-pthread \
--enable-assembler \
--with-extra-charsets=complex \
--with-readline \
--with-ssl \
--with-embedded-server \
--enable-local-infile \
--with-plugins=partition,innobase \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static
(上面老是报错,不换行配置:
./configure --prefix=/application/mysql5.1.72 --with-unix-socket-path=/application/mysql5.1.72/tmp/mysql.sock --localstatedir=/application/mysql5.1.72/data --enable-assembler --enable-thread-safe-client --with-mysqld-user=mysql --with-big-tables --without-debug --with-pthread --enable-assembler --with-extra-charsets=complex --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
)
报错:configure: error: No curses/termcap library found
解决: yum install -y ncurses-devel
make && make install
ln -s /application/mysql5.1.72 /application/mysql
3,初始化登录数据库
a),进入到/home/oldboy/tools/mysql-5.1.72/support-files :
-rw-r--r-- 1 root root 4746 Dec 15 18:10 my-huge.cnf
-rw-r--r-- 1 root root 19779 Dec 15 18:10 my-innodb-heavy-4G.cnf
-rw-r--r-- 1 root root 4720 Dec 15 18:10 my-large.cnf
-rw-r--r-- 1 root root 4731 Dec 15 18:10 my-medium.cnf
-rw-r--r-- 1 root root 2499 Dec 15 18:10 my-small.cnf
b),cp my-small.cnf /etc/my.cnf # /etc/my.cnf 是mysql默认配置文件的路径
c),创建mysql数据存放的地方: mkdir /application/mysql/data -p
授权:chown -R mysql.mysql /application/mysql/
创建初始化数据库:/application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql
如显示结果没有ERROR,并且有两个OK,表示成功
d),启动mysql数据库(第一和第二不要混用,初始化数据库后,选第一就不要用第二了,不然会产生错误,除非重新初始化后再选择)
第一种方法:\cp mysql-5.1.72/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld start
(如果启动有问题,跟踪:sh -x /etc/init.d/mysqld start)
关闭:/etc/init.d/mysqld stop
第二种方法:/application/mysql/bin/mysqld_safe & # 后台启动myql服务
关闭:mysqladmin shutdown
备注:如何重新初始化数据库,再选择启动类型
cd cd /application/mysql
rm -fr data/
killall -9 mysqld
/application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql
cp /home/oldboy/tools/mysql-5.1.72/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
e),登录mysql
全路径:/application/mysql/bin/mysql 或者 将/application/mysql/bin/加入到$PATH环境变量中
vim /etc/profile
结尾加入:PATH="/application/mysql/bin/:$PATH"
让profile生效:. /etc/profile
4,默认mysql是空密码,设置密码
mysqladmin -u root password '123456'
5,mysql安全设置
mysql数据库中的user表只留 root用户,并且host为127.0.0.1和localhost 这2个,其他删除;刷新权限表: flush privileges;
忘记root登录密码怎么办?
解答:/application/mysql/bin/mysqld_safe --skip-grant-table & #忽视授权表, 就可以无密码登录进去改root的密码
二,PHP安装
1,安装前检查apache和mysql的安装路径和服务正常
2,检查安装PHP所需lib库
yum install zlib libxml libjpeg freetype libpng gd curl libiconv zlib-devel libxml2-devel libjpeg-devel freetype-devel libpng-devel gd-devel curl-devel -y
(必须的:freetype-devel , curl-devel , gd-devel , zlib-devel , libpng-devel ,libxml2-devel)
3,安装libiconv libiconv-devel
wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.14.tar.gz
tar zxvf libiconv-1.14.tar.gz
cd libiconv-1.14
./configure --prefix=/usr/local/libiconv
make && make istall
4,编译
tar zxf php-5.3.27.tar.gz
./configure \
--prefix=/application/php5.3.27 \
--with-apxs2=/application/apache/bin/apxs \ #一定指定apache的路径,不然无法被apache调用
--with-mysql=/application/mysql \ #mysql路径正确
--with-xmlrpc \
--with-openssl \
--with-zlib \
--with-freetype-dir \
--with-gd \
--with-jpeg-dir \
--with-png-dir \
--with-iconv=/usr/local/libiconv \
--enable-short-tags \
--enable-sockets \
--enable-zend-multibyte \
--enable-soap \
--enable-mbstring \
--enable-static \
--enable-gd-native-ttf \
--with-curl \
--with-xsl \
--enable-ftp \
--with-libxml-dir
configure: error: Cannot find OpenSSL's <evp.h> #解决: yum install openssl-devel -y
configure: error: Please reinstall the iconv library. #解决:yum install libxslt-devel -y
make && make install
ln -s /application/php5.3.27/ /application/php
检查apache的modules会自动生成:libphp5.so文件
ls /application/apache/modules/
grep libphp5 /application/apache/conf/httpd.conf
5,配置PHP
cp /home/oldboy/tools/php5.3.27/php.ini-production /application/php/lib/php.ini
vim httpd.conf
转到311行即 AddType application/x-gzip .gz .tgz 行的下一行加两行对PHP的解析支持内容:
#AddType application/x-httpd-php .php .php3
AddType application/x-httpd-php .php .phtml
AddType application/x-httpd-php-source .phps
修改默认的daemo用户和组 为 用户为www , 组为www
增加默认主页:
<IfModule dir_module>
DirectoryIndex index.php index.html
useradd www -s /sbin/nologin -M #添加www用户和用户组
授权:chown -R www.www /var/html
apache检查和重启:
/application/apache/bin/apachectl -t
/application/apache/bin/apachectl graceful (或 restart)