linux快速部署mysql

创建software目录并切换
mkdir -p /opt/software && cd /opt/software

下载mysql-RPM包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

yum localinstall安装mysql-RPM包，相比rpm -ivh方式，此方式会自动解决安装依赖
yum localinstall mysql57-community-release-el7-8.noarch.rpm -y
yum repolist enabled | grep “mysql.-community.”

安装mysql
yum install mysql-community-server -y

启动mysql并设置开机自启（查看mysql当前状态）
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

获取mysql初始密码
grep ‘temporary password’ /var/log/mysqld.log

登录mysql
mysql -uroot -p’ZnOsap;&>2VC’

修改mysqlroot密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘1qaz@WSX’;
或（alter user root@localhost identified by ‘1qaz@WSX’;）