title: How to provide SERVICE_NAME in the connection options in mysql npm?
body: <p>I have a JDBC connection string something like this</p>
  
  <pre><code>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1711))(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1712)))(CONNECT_DATA=(SERVICE_NAME=servicename)(SERVER=DEDICATED)))
  </code></pre>
  
  <p>I have created the connection as</p>
  
  <pre><code>var connection = mysql.createConnection({
      host: "hostname",
      port: "1711",
      user: "user", 
      password: "password"
  });
  </code></pre>
  
  <p>How do I also provide SERVICE_NAME (like the jdbc string) to the connection options?
  I am getting the following error without it:</p>
  
  <pre><code>Error: connect ECONNREFUSED &lt;some_ip&gt;:1711
      at Object.exports._errnoException (util.js:1028:11)
      at exports._exceptionWithHostPort (util.js:1051:20)
      at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1090:14)
      --------------------
  </code></pre>
  
  <p>EDIT:
  Changing the port to 1712 gives me a different error after taking a lot of time.</p>
  
  <pre><code>Error: Connection lost: The server closed the connection.
      at Protocol.end (..\node_modules\mysql\lib\protocol\Protocol.js:113:13)
      at Socket.&lt;anonymous&gt; (..\node_modules\mysql\lib\Connection.js:109:28)
      at emitNone (events.js:91:20)
      at Socket.emit (events.js:186:7)
      at endReadableNT (_stream_readable.js:974:12)
      at _combinedTickCallback (internal/process/next_tick.js:74:11)
      at process._tickCallback (internal/process/next_tick.js:98:9)
  </code></pre>
  
  <p>EDIT: Sorry. I didn't see the database was oracle and started trying mysql directly. </p>