lamp搭建

myql 

yum install -y ncurses-devel

 groupadd mysql

useradd mysql  -g mysql  -M -s /sbin/nologin

 tar zxvf mysql-5.1.72.tar.gz  

cd mysql-5.1.72

vim   x.log

./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 \

--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

cat x.log  | bash 

make && make install

mke -j  4          4核心

ln -s /application/mysql5.1.72/    /application/mysql

配置檔案

mysql-5.1.72/support-files/

# cp my-small.cnf.sh  /etc/my.cnf

# mkdir -p  /application/mysql/data 

# chown -R mysql.mysql  /application/mysql/

# /application/mysql/bin/mysql_install_db  --basedir=/application/mysql  --datadir=/application/mysql/data/  --user=mysql                 初始化 

# cp /lamp/mysql-5.1.72/support-files/mysql.server  /etc/init.d/mysqld          啟動腳本

# chkconfig  --add  mysqld

# chkconfig   mysqld  on

# chmod +x /etc/init.d/mysqld

# /etc/init.d/mysqld start

# /application/mysql/bin/mysqld_safe  &       啟動服務

 /application/mysql/bin/mysql           啟動MySQL

vim /etc/profile   修改path

PATH=" /application/mysql/bin:$PATH"

.   /etc/profile 生效

mysql> show databases;

+--------------------+

| Database           |

| information_schema |

| mysql              |

| test               |

3 rows in set (0.00 sec)

# /application/mysql/bin/mysqladmin -u root password  '123456'

# mysql -u root -p

Enter password:

# /application/mysql/bin/mysqladmin -u root   -p123456 password 123123   

mysql> select user,host  from    mysql.user;

             drop user "root"@kaoshi.com;

mysql> flush  privileges;  重新整理權限

php

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

yum install -y libxslt libxslt-devel libxml2 libxml2-devel

tar zxf libiconv-1.14.tar.gz

cd libiconv-1.14

./configure --prefix=/usr/local/libiconv

make

make install

cd ../

=============================

--prefix=/application/php5.3.27 \

--with-apxs2=/application/apache/bin/apxs \     加載PHP子產品

--with-mysql=/application/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

Thank you for using PHP.

# make && make install

 # ln -s /application/php5.3.27/    /application/php

# ll /application/apache/modules/

-rw-r--r-- 1 root root     9115 4月  19 12:33 httpd.exp

-rwxr-xr-x 1 root root 29540885 4月  20 08:53 libphp5.so

# grep libphp5   /application/apache/conf/httpd.conf

LoadModule php5_module        modules/libphp5.so

# ls php.ini-*

php.ini-development  php.ini-production

# diff `ls  php.ini-*`           對比

# cp php.ini-production  /application/php/lib/php.ini  配置檔案

vi /application/apache/conf/httpd.conf

ServerName  127.0.0.1:80                                         100行

    AddType application/x-httpd-php    .php  .phtml                311行

    AddType application/x-httpd-php-source    .phps

User www               65行

Group www

<IfModule dir_module>

    DirectoryIndex  index.php  index.html                 168行

</IfModule>

# groupadd www

# useradd -s /sbin/nologin  -M  -g www      www

# /application/apache/bin/apachectl  restart

# vi hequan.php  

<?php  

        phpinfo();

?>

 vim index.php              測試資料庫

<?php

    //$link_id=mysql_connect('主機名','使用者','密碼');

    $link_id=mysql_connect('localhost','root','oldboy123') or mysql_error();

    if($link_id){

        echo "mysql successful by oldboy !";

    }else{

        echo mysql_error();

    }