title: mysql setup in digital ocean using node express
body: <p>I just decided to switch from google sql to hosting my own mysql server on the droplet where my app is because google sql is so expensive for a side/start up project.</p>
  
  <p>anyway, my problem is, i don't know how to connect to mysql using my app. I can access the mysql using the terminal, i've also manage to setup it on workbench but i can't get the app to connect to it.</p>
  
  <p>this is my config object</p>
  
  <pre><code>DB_HOST=127.0.0.1 
  DB_USER=root
  DB_PASSWORD=*****
  DB_NAME=express_mysql_database00
  </code></pre>
  
  <p>Questions:</p>
  
  <ol>
  <li>List item are these all i need?</li>
  <li>it the db host correct?</li>
  <li>i'm using the mysql module, do i need to use a different one to make this work?</li>
  </ol>