qq_20786911的博客

一、下载并安装mysql官方的yum repository 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安装mysql yum -y install mysql-community-server 此时mysql安装成功 启动mysql systemctl sta

发现用navicat连接mysql提示Access denied for user’root’@‘IP’ (using password: Yes)，而且这个IP为本机的IP，确认用户名和密码输入无误。 解决方法： 设置mysql允许其他IP访问 mysql> update mysql.user set host = ‘%’ where user = ‘root’; mysql> flush privileges; ...