MySQL搭建与使用-01

安装5.7.20

#!/bin/bash

yum remove mariadb* -y
yum install -y libaio-devel

mkdir -p /data
tar xf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz -C /data
cd /data/
mv mysql-5.7.20-linux-glibc2.12-x86_64 mysql
echo 'export PATH=/data/mysql/bin:$PATH' >>/etc/profile
source /etc/profile
useradd mysql -s /sbin/nologin -M
mkdir -p /data/mysql/data

/data/mysql/bin/mysqld --initialize-insecure  --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data
chown -R mysql.mysql /data

cat >>/etc/my.cnf<<QQ
[mysqld]
user=mysql
basedir=/data/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
[mysql]
socket=/tmp/mysql.sock
QQ

cat >>/etc/systemd/system/mysqld.service<<QQ
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation= http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/data/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
QQ
sleep 2
systemctl enable mysqld
systemctl start mysqld
systemctl status mysqld

mysqladmin -uroot -p password 123456
mysql -uroot -p123456 -e "grant all on *.* to root@'%' identified by '123456';"

RPM 安装5.6.20

1.解压
-rw-r--r-- 1 root root 18477656 Oct 28  2019 MySQL-client-5.6.20-1.el6.x86_64.rpm
-rw-r--r-- 1 root root  3397944 Oct 28  2019 MySQL-devel-5.6.20-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 55064712 Oct 28  2019 MySQL-server-5.6.20-1.el6.x86_64.rpm

2.安装
[root@mysql /opt/mysql]# yum install -y libaio libaio-devel
[root@mysql /opt/mysql]# yum remove -y mariadb*

rpm -ivh MySQL-devel-5.6.20-1.el6.x86_64.rpm 
rpm -ivh MySQL-client-5.6.20-1.el6.x86_64.rpm
rpm -ivh MySQL-server-5.6.20-1.el6.x86_64.rpm

3.设置密码和配置文件
cp my.cnf /etc/my.cnf
mysqld_safe --skip-grant-tables --skip-network &
echo "${str// />}"
sleep 8
mysql -uroot -e "update mysql.user set password=password('root@Mysql') where user='root';"
mysql -uroot -e "flush privileges;"
kill -9 `ps -ef |grep -v grep |grep -w 'skip-grant-tables'| awk '{print $2}'`

[root@mysql /opt/mysql]# mysql -uroot -proot@Mysql
mysql> set password=password('root@Mysql');
mysql> flush privileges；
mysql -uroot -proot@Mysql -e "grant all privileges on *.* to 'root'@'%' identified by 'root@Mysql' with grant option;"