远程连接Mysql-EHost 'xxx.xxx.xx.x' is not allowed to connect to this MySQL serverConnection closed by fo

EHost 'xxx.xxx.xx.x' is not allowed to connect to this MySQL serverConnection closed by foreign host.

根据上文CentOS系统Mysql数据库的安装与配置，部署完mysql后，下一步做的是在我们本地远程连接mysql，这时候是无法直接连接的，主要是没有权限，会报出如题的异常：

解决办法：

1> At the console of the box on which mysql server is running type mysql -uroot -p
2> It will prompt you for root pasword is it was set. Once insidew mysql command shell type 
user mysql;
3> grant all privileges on *.* to '<username>'@'<IP>' identified by '<password>';
4> flush privileges;