https://community.cloudera.com/t5/Support-Questions/Hive-Metastore-trouble-with-jbdc-mysql/m-p/204788#M166777 <P><A rel="user" href="https://community.cloudera.com/users/45308/xoffey.html" nodeid="45308">@Michael Coffey</A></P><P>The problem seems to be this:</P><PRE>2017-10-02T19:56:25.684428Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2017-10-02T19:56:25.684440Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2017-10-02T19:56:25.684464Z 0 [Note] Server socket created on IP: '127.0.0.1'.</PRE><P>.</P><P>Your MySQL is starting and listening only on "127.0.0.1" bind_addr. </P><P>You should edit the <STRONG>"bind-address" </STRONG>attribute inside your <STRONG>"/etc/my.cnf" </STRONG> to make it bind on hostname or all listen address.</P><PRE>bind-address=0.0.0.0</PRE><P>.</P><P><A href="https://dev.mysql.com/doc/refman/5.7/en/server-options.html" target="_blank">https://dev.mysql.com/doc/refman/5.7/en/server-options.html</A></P><UL><LI>If the address is<CODE>0.0.0.0</CODE>, the server accepts TCP/IP connections on all server host IPv4 interfaces.</LI><LI>If the address is<CODE>::</CODE>, the server accepts TCP/IP connections on all server host IPv4 and IPv6 interfaces.</LI></UL> Wed, 04 Oct 2017 10:18:24 GMT jsensharma 2017-10-04T10:18:24Z