安装mysql和memcached

#首先确定你是root用户

tar zxfv mysql-5.1.34.tar.gz

cd  mysql-5.1.34

#根据体统类型选择编译方式

#i386体系结构的

#CFLAGS="-O3 -mcpu=pentiumpro" CXX=gcc CXXFLAGS="-O3 -mcpu=pentiumpro -felide-constructors -fno-exceptions -fno-rtti" ./configure --with-raid --enable-thread-safe-client --enable-assembler  --with-server-suffix =" for >>>MySQL Database of Zebra by Yhc<<<" --without-debug --with-extra-charsets=complex --without-isam --prefix=/usr/local/mysql --without-bench

#64位系统，x86_64

#CFLAGS="-O3 -m64" CXX=gcc CXXFLAGS="-O3 -m64 -felide-constructors -fno-exceptions -fno-rtti" ./configure --with-raid --enable-thread-safe-client --enable-assembler  --with-server-suffix =" for >>>MySQL Database of Zebra by Yhc<<<" --without-debug --with-extra-charsets=complex --without-isam --without-server --prefix=/usr/local/mysql --without-bench --with-archive-storage-engine 

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --enable-thread-safe-client --enable-assembler  --with-server-suffix =" for >>>MySQL Database of Zebra by Yhc<<<" --without-debug --with-extra-charsets=complex --prefix=/usr/local/mysql  

#然后根据CPU数量进行编译

make -j 8 && make install

#添加用户

groupadd mysql && useradd -g mysql mysql

#创建目录

mkdir /usr/local/mysql/data && mkdir /usr/local/mysql/run && mkdir /usr/local/mysql/log && mkdir /usr/local/mysql/var

#更改mysql目录所有者

#chgrp mysql -R /usr/local/mysql && chown mysql -R /usr/local/mysql

#增加打开文件数量

ulimit -n 2048

#添加PATH

echo "PATH=\"/usr/local/mysql/bin:\$PATH\"" >> /etc/profile && export PATH="/usr/local/mysql/bin:$PATH"

#strip可执行文件

strip /usr/local/mysql/libexec/mysqld

#添加LIB PATH

echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf && ldconfig

#将my.cnf文件cp到/etc目录下

/bin/cp -r /usr/local/mysql/share/mysql/my-huge.cnf  /etc/my.cnf && chown mysql:mysql /etc/my.cnf  

sed -i 's/skip-federated/#skip-federated/' /etc/my.cnf

cd /usr/local/mysql/bin

ln -s ./mysql ./test_mysql

ln -s ./mysqladmin ./adminmysql

ln -s ./mysql_install_db ./install_db_mysql

ln -s ./mysqld_safe ./safe_mysqld

#初始化Mysql表

cd /usr/local/mysql/bin

./install_db_mysql --user=mysql

chown -R root /usr/local/mysql && chown -R  mysql /usr/local/mysql/var && chgrp -R mysql /usr/local/mysql  

pkill -9  mysql

#su - mysql -c "mysqld_safe --skip-name-resolve --open-files-limit=20480 &"

#完成后，删除空的用户名帐号。

#/usr/local/mysql/bin/mysql -uroot -e "use mysql;delete from user where "User"='';"

#为本地帐户创建密码

#/usr/local/mysql/bin/mysql -uroot -e "set password for root@"localhost" = password('123456');"

#/usr/local/mysql/bin/mysql -uroot -p123456 -e "use mysql;update user set Password=password('123456') where "Host"='localhost.localdomain';flush privileges;"

#关闭服务器

#su - mysql -c "mysqladmin -u root -pPASSWORD shutdown"

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

#!/bin/bash

#安装libevent

tar zxvf libevent-1.4.14b-stable.tar.gz

cd libevent-1.4.14b-stable

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

make

make install

#ln -s /usr/local/lib/libevent-1.4.so.2 /usr/lib64/

cd ..

#安装memcached

tar zxvf  memcached-1.2.6.tar.gz

cd memcached-1.2.6 

./configure --prefix=/usr/local/ --with-libevent=/usr/local/

make

make install

#运行memcached时候用root账号运行，格式：

#./memcached -d -u root -m 2048 -l 172.17.13.253 -p 11211 

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

测试环境部署

一、服务器环境部署

1、   所需软件

mysql-5.1.34.tar.gz   （数据库包）

httpd-2.2.10.tar.gz    （apache包，做客户端自动更新需要，仅部署服务器环境可不装）

libevent-1.4.7-stable.tar.gz（libevent库，安装memcached需）

memcached-1.2.6.tar.gz   （积分、鲜花服务器需要配置，作为积分、鲜花缓存） 

2、   安装过程

1）mysql安装

首先:

   以root帐号登录linux,创建mysql用户跟mysql组

 shell> groupadd mysql

shell> useradd -g mysql mysql

   解压文件

 shell> tar zvxf mysql-4.1.18.tar.gz

 shell> cd mysql-4.1.18

   进行安装配置,强制使用pthread库,以及以线程方式编译客户端

 shell>./configure--prefix=/usr/local/mysql --with-pthread --enable-thread-safe-client

 shell >make

 shell>make install

#添加PATH

echo"PATH=\"/usr/local/mysql/bin:\$PATH\"" >>/etc/profile && export PATH="/usr/local/mysql/bin:$PATH"

#增加打开文件数量

ulimit-n 4096

#打开CORE文件

ulimit-c unlimited

通过以上步骤就安装好了mysql接下来配置mysql

其次：

 把support-files下的my-medium.cnf文件复制到etc目录下

 shell>cpsupport-files/my-medium.cnf /etc/my.cnf

(进入/etc目录下打开my.cnf，注释掉其中的skip-federated  不然初始化数据库会失败)

 切换到mysql的安装目录,在本例子中mysql安装在 /usr/local/mysql

 shell >cd/usr/local/mysql

 初试化数据库

 shell >bin/mysql_install_db  --user=mysql

（在/usr/local/mysql/bin目录下执行./mysql_install_db --user=mysql）

 给相应的用户分配权限(/usr/local/mysql目录下执行)

 shell >chown-R root .

 shell >chown -R mysql var         

 shell >chgrp -R mysql .  （该指令将数据目录所有属性改为mysql用户）

把启动、停止命令拷贝到/usr/sbin目录下并赋权

shell >cp mysql.-5.1.34/support-files/mysql.server/usr/sbin      (/etc/init.d)

shell>chmod 777 /usr/sbin/mysql.server

 

 通过下面的命令启动mysql

 shell>bin/mysqld_safe -user=mysql &

(对root用户设置密码：

在/usr/local/mysql/bin目录下执行

 ./mysqladmin -u root password '123456'

用root账户登陆：

在/usr/local/mysql/bin目录下执行 ./mysql -u root -p)

 

 通过以上步骤就可以使用mysql数据库了。

 

（建立一个管理员账号,用root权限登陆mysql后执行以下语句：

GRANTALL ON *.* to pzzx IDENTIFIED BY "pzzx" WITH GRANT OPTION;）

 

GRANT ALL PRIVILEGES ON *.* TO root@'172.17.112.21'IDENTIFIED BY '123456' WITH GRANT OPTION;