title: Connection timeout between dataproc and sql (CPB100 - Lab3b)
body: <p>I try to run a script from Google CPB100 - Lab3b (train_and_apply.py) with dataproc against SLQ (mysql ddbb) but I get a timeout.</p>
  
  <pre><code>Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
  </code></pre>
  
  <p>From the dataproc master I can connect with the mysql command line, but no with the python commands from the script. What can I do to diagnostic this issue?</p>
  
  <p>Success</p>
  
  <pre><code>$&gt; mysql --host=35.194.7.XXX --user=root --password 
  </code></pre>
  
  <p>Timeout</p>
  
  <pre><code>$&gt; pyspark
  
  %&gt; jdbcDriver='com.mysql.jdbc.Driver'
  %&gt; jdbcUrl='jdbc:mysql://35.194.7.XXX:3306/recommendation_spark?user=root&amp;password=XXXX'
  %&gt; dfRates = sqlContext.read.format('jdbc').options(driver=jdbcDriver, url=jdbcUrl, dbtable='Rating').load()
  </code></pre>