目录
rpm -qa | grep mysql
说明没有安装mysql
如果有:
rpm -e --nodeps mysql
强力删除模式,如果使用上面命令删除时,提示有依赖的其它文件,则用该命令可以对其进行强力删除,在删除完以后我们可以通过 rpm -qa | grep mysql 命令来查看mysql是否已经卸载成功!!
cd /usr/local/src
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum repolist all
yum install -y mysql-server
systemctl start mysql
systemctl enable mysqld
mysql_secure_installation
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
以登录到MySQL的安全,我们需要的电流根用户密码。如果你刚刚安装MySQL,你还没有设置root密码,密码将是空白的,所以你应该在这里按回车。
登录成功。
选中【MySQL】数据库
use mysql;
输入修改密码语句
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
改完密码刷新一下权限
FLUSH PRIVILEGES;
update user set host='%' where user='root' and host='localhost';
如果是在线的,例如是阿里的【ECS】服务器添加对应【安全组】即可
不是的话得自己设置开放3306端口,如下:
# 安装 iptables
yum install iptables iptables-services iptables-utils
systemctl start iptables
systemctl status iptables
# 设置iptables
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
iptables -I INPUT -p udp --dport 3306 -j ACCEPT
iptables -nL
# 设置firewalld
firewall-cmd --state
firewall-cmd --permanent --zone=public --add-port=3306/tcp
firewall-cmd --permanent --zone=public --add-port=3306/udp
# 重启
systemctl restart firewalld.service
# 或者
firewall-cmd --reload
希望能给大家带来一定的帮助。