install mysql database

最新推荐文章于 2022-08-23 09:59:31 发布

原创最新推荐文章于 2022-08-23 09:59:31 发布 · 489 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#mysql #database #input #null #file

mysql 专栏收录该内容

2 篇文章

订阅专栏

本文提供了一个用于自动化安装MySQL数据库的Shell脚本。该脚本引导用户完成安装文件的选择、安装路径的确认等步骤，并配置了必要的环境文件。此外，脚本还包括了创建数据库及表的命令。

#!/bin/sh
#
#install  mysql database
#
echo -e "/n/n"
while echo -en "/nAre you sure install mysql database now (yes/no)?";read qr
do
 if [ "$qr" = "yes" ]; then
  break
 elif [ "$qr" = "no" ]; then
  exit 1
 fi
done

while echo -en "/nPlease input install file(tar.gz):";read ifile
do
 if [ !  -e "$ifile" ] ; then
  echo " Not found install file !"
  continue
 else
  break
 fi
 
done

while echo -en "/nPlease input install to path:";read ipath
do
 while echo -en "/ninstall to:$ipath  (yes/no)?";read qr
 do
  if [ "$qr" = "yes" ] ; then
   break 2
  elif [ "$qr" = "no" ] ; then
   break 1
  fi
 done
done

mkdir -p $ipath
tar -zxvf $ifile -C $ipath > installmysql.log
mysqldir=$ipath"/"`ls ${ifile}|awk -F .tar.gz '{ print $1}'`

#link directory
if [ -h "/usr/local/mysql" ] ; then
 rm -f /usr/local/mysql
fi
ln -s $mysqldir /usr/local/mysql
#file name
#add content
etcfile=/etc/my.cnf
touch $etcfile
echo "[mysqld]">$etcfile
echo "  datadir=/usr/local/mysql/data">>$etcfile
echo "  port=3307">>$etcfile
echo "  socket=/tmp/mysql.sock">>$etcfile
echo "[mysql.server]">>$etcfile
echo "  user=mysql">>$etcfile
echo "  basedir=/usr/local/mysql">>$etcfile
echo "[safe_mysqld]">>$etcfile
echo "  err-log=/usr/local/mysql/log/mysqld.log">>$etcfile
echo "  pid-file=/tmp/mysqld.pid">>$etcfile
#adduser
groupadd mysql
useradd -g mysql mysql
#
if [ -h /bin/mysql ] ; then
 rm -f /bin/mysql
fi
ln -s /usr/local/mysql/bin/mysql /bin/mysql

#
echo "/usr/local/mysql/bin/mysqld_safe &">>/etc/rc.local
#initial mysqldb
cp /usr/local/mysql/share/fill_help_tables.sql /usr/local/mysql/support-files/fill_help_tables.sql
cp /usr/local/mysql/share/mysql_fix_privilege_tables.sql /usr/local/mysql/support-files/mysql_fix_privilege_tables.sql
chgrp -R mysql $mysqldir
chown -R mysql $mysqldir
chmod -R 700 $mysqldir
 
cd /usr/local/mysql/
./scripts/mysql_install_db --user=mysql >installmysql.log
#Run mysqld
/usr/local/mysql/bin/mysqld_safe &
sleep 10
/usr/local/mysql/bin/mysqladmin create mydb

#------------------------------------------------------------------------------------------------------------
t1="CREATE TABLE MESSAGE_STATS (id_stats tinyint(3) unsigned NOT NULL,description varchar(100) default NULL,PRIMARY KEY  (id_stats)) ENGINE=InnoDB DEFAULT CHARSET=latin1;"
/usr/local/mysql/bin/mysql --database=mydb  --execute="$t1"
echo -e "/n/n LineHandlerGW mysql database install success!/n/n"