#!/bin/sh

#一键安装二进制mysql

#xiaogao 20150922

#required soft

#mysql-5.5.32-linux2.6-x86_64.tar.gz

#需要上面的二进制mysql软件，并且放在 /home/lvnian/tools/目录下

#安装相关依赖库

#安装相关依赖库

yum install ncurses-devel libaio-devel -y

#创建相关mysql用户

groupadd mysql

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

tail -1 /etc/passwd

#获取mysql数据库软件

mkdir -p /home/lvnian/tools/

cd /home/lvnian/tools/

4. 安装mysql数据库

tar xf mysql-5.5.32-linux2.6-x86_64.tar.gz

ls

mkdir /application/

mv mysql-5.5.32-linux2.6-x86_64 /application/    

ln -s /application/mysql-5.5.32-linux2.6-x86_64 /application/mysql

ll /application/

#创建数据目录

mkdir -p /application/mysql/data

chown -R mysql.mysql /application/mysql/data

#初始化数据库

cd /application/mysql/scripts/

./mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql

###出现2个ok就是初始化数据库成功

#配置mysql命令全局路径

echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile

. /etc/profile

echo $PATH

which mysql

#设置mysql配置文件

cd /application/mysql

cp support-files/my-small.cnf /etc/my.cnf

#复制启动脚本到/etc/init.d/mysql

cd /application/mysql

cp support-files/mysql.server /etc/init.d/mysqld

chmod 700 /etc/init.d/mysqld 

sed -n '/^basedir=\|^datadir=/p' /etc/init.d/mysqld

sed -i 's#^datadir=#datadir=/application/mysql/data#g' /etc/init.d/mysqld

sed -i 's#^basedir=#basedir=/application/mysql#g' /etc/init.d/mysqld

sed -n '/^basedir=\|^datadir=/p' /etc/init.d/mysqld

/etc/init.d/mysqld start

#

echo “-------------mysql-----------------”

sleep 5

netstat -lnt |grep 3306

lsof -i :3306

########进入mysql

mysql