mysql连接报错：ERROR 2002 (HY000):Can't connect to MySQL server on '172.18.0....

littlestupid

使用MySQL客户端连接远程amoeba进行远程控制数据库报错：
5 x- T* Z* {$ L8 d
5 @7 I* t7 _* L6 i& oroot@uduntu:~# mysql -u root -P8066  -h 172.18.0.4 -p
6 j" a- G* ?) R# [2 X, i1 wEnter password:
7 W2 D3 b0 I( [+ }ERROR 2002 (HY000): Can't connect to MySQL server on '172.18.0.4' (115)

+ N" U* S/ i* _0 _求解答？？？？在线等谢谢，可进行远程协调

youOK

为啥一看到程序，就头大

thinkfunny

Maybe the root is not allowed to connect mysql server from a remoting host. I advise you to create a new user instead of root.
& P, u2 @* }+ I4 v% S  G" V
create user 'joey'@'%' identified by 'yourpassword';
grant all privileges on yourdb.* to 'joey'@'%'
0 o6 K2 n. ]/ s( ~you can replace '%' with your host（if not, connecting mysql server from every remoting host is allowed）

xiaogegepcb

是不是应该检查下 mysql服务是否开了远程权限