【数据库安全】MySql远程访问设置

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME‘@‘%‘ IDENTIFIED BY ‘PASSWORD‘ WITH GRANT OPTION;
#允许单个ip 修改用户名和密码为你自己的
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME‘@‘1.2.3.4‘ IDENTIFIED BY ‘PASSWORD‘ WITH GRANT OPTION;
#最后
mysql> FLUSH PRIVILEGES;

• service iptables status

• service iptables stop

• service iptables start

【数据库安全】MySql远程访问设置

标签：用户名   net   flush   name   str   serve   stop   客户   数据