安装mysql和memcached_linux memcached 安装后与mysql-优快云博客

本文链接：https://blog.youkuaiyun.com/chengxuyuanyonghu/article/details/39502097

本文提供了一套完整的部署指南，包括MySQL数据库的安装与配置，以及Memcached服务器的安装与运行，适用于服务器环境。重点介绍了安装流程、配置细节和初始化数据库的方法。

#!/bin/bash

#首先确定你是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