这个也是自己在学习了一段linux之后,自己写的一个一键安装mysql单实例。脚本目录大概是这样的,一下这个是我安装文件里面的目录,其实脚本我只是将安装过程用脚本写出来而已。个人感觉脚本里面的安装过程没有变化。不懂大家手动安装过程一不一样。

   目前安装我的系统是CentOS release 5.6 32  Linux 2.6.18-238.el5。mysql软件:mysql-5.0.45.tar.gz  目前我也不是很清楚大家使用得比较广泛的版本是什么版本,应该没有接触过真正的实际案例。[PS:本人英文考试没有一次及格过,文中的英文语法错误应该是正常的,请大家忽略。]

1)创建mysql用户

2)编译、安装mysql--编译参数要正确,不带mysql版本

3)拷贝配置文件和mysql

4)创建数据库文件

5)授权mysql用户访问 chown -R mysql.mysql /usrl/local/mysql

6)配置全局路径

7)初始化数据库

8)启动mysql数据库

-----------------------------------低调的分割线------------------------------------------

#!/bin/bash

#       Authore:liwentong

#       Mail:

#       V.1-0  13-09-14

#       Functione: Install the mysql for sole

#------Determine if have mysql runing---#

/bin/netstat -tln |grep 3306 >/dev/null  

[ $? -eq 0 ] && \

/bin/echo "Can't install because have mysql running.." && exit 1

[[ -d /usr/local/mysql-5.0.45  || -d /usr/local/mysql ]] && \

/bin/echo  "You already  install mysql softword " && exit 1

#----------Add mysql user --------------#

/bin/grep mysql: /etc/shadow

[ $? -ne 0 ] && \

{

/usr/sbin/groupadd mysql

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

}

#------------Install the soft-----------#

[ ! -f /root/tools/mysql-5.0.45.tar.gz ] && \

echo "You have't sofaword" >> /tmp/mysql_install.log && exit 1

cd /root/tools

/bin/tar zxf mysql-5.0.45.tar.gz

cd mysql-5.0.45

./configure \

--prefix=/usr/local/mysql \

--with-unix-socket-path=/usr/local/mysql/tmp/mysql.scok \

--localstatedir=/usr/local/mysql/data \

--enable-assembler \

--enable-thread-safe-client \

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

#1>/dev/null  2>>/tmp/mysql_install.log

if [ $? -ne 0 ];then

       echo "Config error " >> /tmp/mysql_install.log && exit 1

else  

       echo "Config sucessful " >> /tmp/mysql_install.log

fi

make &&  make install

if [ $? -ne 0 ];then  

       echo "Make && make install error" >>/tmp/mysql_install.log && exit 1

else

       echo "Make && make install sucessful" >>/tmp/mysql_install.log

fi

#/bin/ln -s /usr/local/mysql-5.0.45  /usr/local/mysql

#----------Copy the config and mysqld----#

/bin/cp /root/tools/mysql-5.0.45/support-files/my-small.cnf /etc/my.cnf

/bin/cp /root/tools/mysql-5.0.45/support-files/mysql.server /usr/local/mysql/bin/mysqld

#----mkdir DATA and Authorization mysql--#

#创建数据目录及授权用户

/bin/mkdir -p /usr/local/mysql/data

/bin/chown -R mysql.mysql /usr/local/mysql/

#-----Configure the PATH and mysqld-----#

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

source /etc/profile

/bin/cp /root/tools/mysql-5.0.45/support-files/mysql.server /etc/rc.d/init.d/mysqld

/bin/chmod 750 /usr/local/mysql/bin/mysqld

/bin/chmod 750 /etc/rc.d/init.d/mysqld

#---Initialization and Starting MySQL---#

/usr/local/mysql/bin/mysql_install_db    --user=mysql

echo "/usr/local/mysql/bin/mysqld_safe & " >> /etc/rc.local

/usr/local/mysql/bin/mysqld_safe &

/bin/netstat -tln |grep 3306

[ $? -eq 0 ] && echo  "Mysql Staring" >> /tmp/mysql_install.log || echo "Mysql is not staring" >> /tmp/mysql_install.log

-----------------------------低调的分割线------------------------------------------------

不懂为什么正常的安装完成之后,通过这个mysqld文件来进行启动,就是启动不起来。而如果是通过/usr/local/mysql/bin/mysqld_safe & 就是能够启动起来。这个不懂是什么原因。如果有知道,也请在评论中告诉我吧。

另:mysqladmin -uroot password "修改的密码"