阿里云yum安装mysql及远程连接

步骤1：安装

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

步骤三联安装

步骤2 启动和终止

systemctl start  mysqld.service

systemctl status mysqld.service

service mysqld restart

步骤3 初始化密码

①首先查找默认密码

[root@ruge /]# grep "password" /var/log/mysqld.log
2019-10-26T02:52:16.792622Z 1 [Note] A temporary password is generated for root@localhost: ktFVgHWul9(4

②登录
[root@ruge /]# mysql -uroot -p
Enter password:

③设置validate_password_policy值
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)


mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '数据库密码';
Query OK, 0 rows affected (0.01 sec)

④给阿里云配置远程登录权限

⑤可视化工具授权

grant all on *.* to root@'%' identified by '数据库密码';

⑥可视化工具登录

这里吧真是的ip隐藏了   哈哈   到这里aliyun集成mysql就完成了

 

mysql配置文件

vim /etc/my.cnf