MySQL5.7 安装

下载mysql数据设置重启查看MySQL运行状态，运行状态如图：密码就是 看/var/log/mysqld.log 最后一行，最后一部分就是密码step3: 授予root用户远程访问权限：目录地址

下载

[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm [root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm [root@localhost ~]# yum -y install mysql-community-server

mysql数据设置

[root@localhost ~]# systemctl start mysqld.service

重启

[root@localhost ~]# systemctl restart mysqld.service

查看MySQL运行状态，运行状态如图：

[root@localhost ~]# systemctl status mysqld.service

[root@localhost ~]# grep "password" /var/log/mysqld.log [root@localhost ~]# mysql -uroot -p

密码就是 看/var/log/mysqld.log 最后一行，最后一部分就是密码

set global validate_password_policy=0; SET PASSWORD = PASSWORD('Xiaoming250');

step3: 授予root用户远程访问权限：

grant all privileges on *.* to 'root' @'%' identified by 'Xiaoming250' WITH GRANT OPTION; flush privileges;

目录地址

[root@localhost mysql]# pwd /var/lib/mysql