自动化安装linux genric msyql 亲测有效

该博文是讲如何自动化安装linux genric mysql。
1、解压安装包
[root@localhost ~]# tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz -C /usr/local/
[root@localhost local]# ln -s mysql-8.0.13-linux-glibc2.12-x86_64 mysql
2、修改安装目录的权限
[root@localhost local]# chown -R root:mysql mysql
3、创建数据文件存放路径
[root@localhost mysql]# mkdir /data;chown -R mysql:mysql /data
4、添加mysql的bin路径到环境变量中
[root@localhost mysql]# vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH
export MYSQL_PS1="(\u@\h:\p) [\d]> "
[root@localhost mysql]# source /etc/profile
5、初始化数据库，使用mysql用户，数据文件存放在/data路径下
[root@localhost mysql]# bin/mysqld --initialize --user=mysql --datadir /data
6、添加mysql服务，并添加开机启动
[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysql.server ##将MySQL加入到服务自启动
[root@localhost mysql]# chkconfig --add mysql.server
[root@localhost mysql]# chkconfig --list mysql.server
7、启动msyql服务
[root@localhost mysql]# /etc/init.d/mysql.server start ##通过服务启动MySQL
8、初始化数据库完成后，查看初始密码
[root@localhost mysql]# grep ‘temporary password’ /var/log/mysqld.log
9、登录msyql，并修改密码
[root@localhost mysql]# mysql -uroot -p
Enter password:
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user user() identified by ‘123456’;
Query OK, 0 rows affected (0.05 sec)

以下为自动化安装mysql脚本

#!/bin/bash

yum install -y libaio > /dev/null 2>&1
# 先将原先的mysql进程杀掉
for mysql_id in `ps -aux|grep mysql |grep -v 'grep' |awk -F' ' '{print $2}'`
do
	kill -9  $mysql_id
done 
# 添加mysql的组
if id -g mysql > /dev/null 2>&1
then
	echo "mysql group exists"
else
	groupadd mysql > /dev/null 2>&1 && echo 'creating mysql group sucess'
fi

# 添加mysql用户
if id -u mysql > /dev/null 2>&1
then
	echo "mysql user exists"
else
	useradd -r -g mysql -s /sbin/nologin mysql > /dev/null 2>&1 && echo 'creating mysql user success'
fi
# 定义mysql变量
mysql_install_dir=/usr/local
custom_data_dir=/data
[ -d $custom_data_dir ] || mkdir -p $custom_data_dir
chown -R mysql:mysql $custom_data_dir
cd /root
tar -zxvf $(/usr/bin/ls mysql*.tar.gz) -C ${mysql_install_dir} > /dev/null 2>&1 && echo 'uncompress mysql install package success'
cd ${mysql_install_dir}
ln -s $(/usr/bin/ls -d mysql-*) mysql
echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile 
source /etc/profile && echo $PATH


cat << EOF > /etc/my.cnf
[mysql]
prompt=(\\u@\\h) [\\d]> \\

[mysqld]
basedir=/usr/local/mysql 
datadir=/data
port=3306
log_error=mysqld.log
EOF


chown -R root:mysql mysql*
ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
ln -s /usr/lib64/libncurses.so.6.1 /usr/lib64/libncurses.so.5
cd mysql
bin/mysqld --initialize --user=mysql --datadir /data
#grep 'temporary password' /data/mysqld.log|awk -F: '{print $4}' > /tmp/mysqlpasswd.txt
mysql_password=$(grep 'temporary password' /data/mysqld.log|awk -F: '{print $4}'|sed 's/[[:space:]]//g')
echo "$mysql_password" > ~/mysql_passwd
cp support-files/mysql.server /etc/init.d/mysql.server
chkconfig --add mysql.server
chkconfig  mysql.server on
[ $(/etc/init.d/mysql.server restart | grep "Starting MySQL. SUCCESS"|echo $?) -eq 0 ]
echo 'install success...'
echo "mysql initialize password is '${mysql_password}'"

执行完成以上shell脚本后，重启系统，登录mysql验证是否正常登录。