LNMP搭建论坛（1）sql数据库配置

1． 挂载镜像
mount /dev/cdrom /opt
2、配置yum源
cd /etc/yum.repos.d
ls
cd /etc/yum.repos.d/
ls
vi z.repo
vi z.repo
3、安装yum源文件
yum install -y apr* autoconf automake bison bzip2 bzip2* compat* cpp curl curl-devel fontconfig fontconfig-devel freetype freetype* freetype-devel gcc gcc-c++ gd gettext gettext-devel glibc kernel kernel-headers keyutils keyutils-libs-devel krb5-devel libcom_err-devel libpng libpng-devel libjpeg* libsepol-devel libselinux-devel libstdc++-devel libtool* libgomp libxml2 libxml2-devel libXpm* libtiff libtiff* make mpfr ncurses* ntp openssl openssl-devel patch pcre-devel perl php-common php-gd policycoreutils telnet t1lib t1lib* nasm nasm* wget zlib-devel
4 、移动文件
cd zj
ls
mv cmake-2.8.11.2.tar.gz /usr/local/src
mv libpng-1.6.12.tar.gz /usr/local/src
mv php-5.5.14.tar.gz /usr/local/src
mv Discuz_X3.2_SC_GBK.zip /usr/local/src
mv libvpx-v1.3.0.tar.bz2 /usr/local/src
mv t1lib-5.1.2.tar.gz /usr/local/src
mv freetype-2.5.3.tar.gz /usr/local/src
mv mysql-5.6.19.tar.gz /usr/local/src
mv tiff-4.0.3.tar.gz /usr/local/src
mv jpegsrc.v9a.tar.gz /usr/local/src
mv nginx-1.6.0.tar.gz /usr/local/src
mv yasm-1.2.0.tar.gz /usr/local/src
mv libgd-2.1.0.tar.gz /usr/local/src
mv openssl-1.0.1h.tar.gz /usr/local/src
mv libmcrypt-2.5.8.tar.gz /usr/local/src
mv pcre-8.35.tar.gz /usr/local/src
mv zlib-1.2.8.tar.gz /usr/local/src
5、解压文件
ls
tar xzvf Discuz_X3.2_SC_GBK.zip
unzip Discuz_X3.2_SC_GBK.zip
ls
tar xzvf freetype-2.5.3.tar.gz
ls
tar xzvf jpegsrc.v9a.tar.gz
ls
tar xzvf libgd-2.1.0.tar.gz
ls
tar xzvf libpng-1.6.12.tar.gz
ls
tar jxvf libvpx-v1.3.0.tar.bz2
ls
tar xzvf mysql-5.6.19.tar.gz
ls
tar xzvf nginx-1.6.0.tar.gz
ls
tar xzvf openssl-1.0.1h.tar.gz
ls
tar xzvf openssl-1.0.1h
tar xzvf openssl-1.0.1h.tar.gz
ls
tar xzvf pcre-8.35.tar.gz
ls
tar xzvf php-5.5.14.tar.gz
ls
tar xzvf t1lib-5.1.2.tar.gz
ls
tar xzvf tiff-4.0.3.tar.gz
ls
tar xzvf yasm-1.2.0.tar.gz
ls
tar xzvf zlib-1.2.8.tar.gz
6、执行
./configure
cd cmake-2.8.11.2/
/configure
make
make install
7、添加用户
cd ..
useradd mysql -s /sbin/nologin
mkdir -p /usr/local/mysql/var
chown -Rf mysql:mysql /usr/local/mysql
8、解压编译安装数据库
cd mysql-5.6.19/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/var -DSYSCONFDIR=/etc
make

make install
9、删除文件，生成数据库
rm -rf /etc/my.cnf [[email protected] mysql-5.6.19
cd /usr/local/mysql
./scripts/mysql_install_db –user=mysql –basedir=/usr/ local/mysql –datadir=/usr/local/mysql/var/
10、把生成的文件连接到/etc的数据库
ln -s my.cnf /etc/my.cnf
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod 755 /etc/rc.d/init.d/mysqld
11、编辑脚本第46,47行
vim /etc/rc.d/init.d/mysqld
46 basedir=/usr/local/mysql
47 datadir=/usr/local/mysql/var/
12、启动服务
service mysqld start
chkconfig mysqld on/
13、编辑配置文件，第74行添加
vim /etc/profile
74： export PATH=$PATH:/usr/local/mysql/bin
14、然后source加载
source /etc/profile
15、链接文件
mkdir /var/lib/mysql
ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
ln -s /usr/local/mysql/include/mysql /usr/include/mysql
16、调用
mysql_secure_installation