前言:
我的第二篇文章就是再Linux系统上下载MySQL,现在写一个一键安装的shell脚本,步骤详细解释见我的第二篇文章。
思路(按步解读脚本):
用中间变量承接模糊查询指令,删掉查询到的文件,进入/opt目录,下载并安装mysql 5.6,授权,修改配置文件,重启MySQL,不进入MySQL就操作MySQL,设置用户名密码,刷新,开启远程登录MySQL权限,刷新。
脚本全内容:
#install mysql 5.6
function mysqlSetup(){
mars=`rpm -qa | grep mariadb`
rpm -e --nodeps $mars
cd /opt/
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server -y
chown -R root:root /var/lib/mysql
chown root /var/lib/mysql/
sed -i '21a character-set-server=utf8' /etc/my.cnf
echo '[client]' >> /etc/my.cnf
echo 'default-character-set=utf8' >> /etc/my.cnf
echo '[mysql]' >> /etc/my.cnf
echo 'default-character-set=utf8' >> /etc/my.cnf
service mysqld restart
mysql -uroot -e "use mysql;update user set password=password('ok') where user='root';"
mysql -uroot -pok -e 'flush privileges;'
mysql -uroot -pok -e 'GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "ok";'
mysql -uroot -pok -e 'flush privileges;'
}
mysqlSetup