社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
安装wget: yum install wget
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server
刚安装的mysql,没有设置密码,可以直接进入数据库修改,步骤如下
可以先自己测试一下远程是否可以用,有的可以不用设置,默认已经开发权限
1.将3306端口加入防火墙
/sbin/iptables -I INPUT -p tcp --dport 3306-j ACCEPT #添加端口3306
/etc/rc.d/init.d/iptables save #保存设置
/etc/rc.d/init.d/iptables status #查看防火墙状态
mysql -u root -p password //进入mysql控制台
mysql>use mysql;
mysql>update user set host = '%' where user = 'root'; //这个命令执行错误时可略过
mysql>flush privileges;
mysql>select host, user from user; //检查‘%’ 是否插入到数据库中
mysql>quit
mysql-community-client-5.6.37-2.el6.x86_64
mysql-community-release-el6-5.noarch
mysql-community-libs-5.6.37-2.el6.x86_64
mysql-community-server-5.6.37-2.el6.x86_64
mysql-community-common-5.6.37-2.el6.x86_64
rpm -ev mysql-community-server-5.6.37-2.el6.x86_64
rpm -ev mysql-community-client-5.6.37-2.el6.x86_64
rpm -ev mysql-community-release-el6-5.noarch
rpm -ev --nodeps mysql-community-common-5.6.37-2.el6.x86_64
rpm -ev --nodeps mysql-community-libs-5.6.37-2.el6.x86_64
3.找之前老版本mysql的目录
/etc/selinux/targeted/active/modules/100/mysql
/usr/share/mysql
/var/lib/mysql
/var/lib/mysql/mysql
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rm -rf /usr/share/mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql/mysql
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!