linux Centos7远程登陆mysql、修改密码和常用命令

远程登陆mysql
关闭firewall：
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl mask firewalld.service
安装iptables防火墙
yum install iptables-services -y
启动设置防火墙
systemctl enable iptables
systemctl start iptables
4.查看防火墙状态
systemctl status iptables
5编辑防火墙，增加端口
vi /etc/sysconfig/iptables #编辑防火墙配置文件
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 21 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 443 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
:wq
重启配置，重启系统
systemctl restart iptables.service #重启防火墙使配置生效
systemctl enable iptables.service #设置防火墙开机启动

修改密码
[root@bogon ~]# mysql -uroot -p (直接点击回车，密码为空)
mysql> use mysql;
mysql> update mysql.user set authentication_string=password(‘123456’) where user=‘root’;
mysql> flush privileges;

设置远程访问
grant all privileges on . to ‘root’ @’%’ identified by ‘123456’;
flush privileges;

启动命令
service mysqld start

关闭命令
service mysqld stop

重启命令
service mysqld restart

查看服务状态
service mysqld restart