mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sys                |

+--------------------+

4 rows in set (0.01 sec)

mysql> use mysql;   # 切换到mysql数据库

  Reading table information for completion of table and column names

  You can turn off this feature to get a quicker startup with -A

  Database changed

mysql> select host,user from user;  # 查询user表

  +-----------+---------------+

  | host      | user          |

  +-----------+---------------+

  | %         | root          |

  | localhost | mysql.session |

  | localhost | mysql.sys     |

  +-----------+---------------+

  5 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root密码' WITH GRANT OPTION;   # 修改权限

  Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;

  Query OK, 0 rows affected (0.00 sec)

mysql>insert into user (host,user,password) values('122.114.155.163','admin',password('ygpassword'));

mysql>FLUSH PRIVILEGES;

mysql>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'122.114.155.163'IDENTIFIED BY 'ygpassword' WITH GRANT OPTION;

mysql>FLUSH PRIVILEGES;

 开启： chkconfig iptables on

 关闭： chkconfig iptables off

 开启： service iptables start

 关闭： service iptables stop 

 vim /etc/sysconfig/iptables

 -A INPUT -m state --state NEW -m tcp -p tcp --dport  -j ACCEPT

 -A INPUT -m state --state NEW -m tcp -p tcp --dport  -j ACCEPT

 -A INPUT -m state --state NEW -m tcp -p tcp --dport  -j ACCEPT

 -A INPUT -m state --state NEW -m tcp -p tcp --dport  -j ACCEPT

 -A INPUT -m state --state NEW -m tcp -p tcp --dport  -j ACCEPT

 service iptables restart