title: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' in cloud9 ide
body: <p>I am running a sailsJS project on Cloud9.io and using mysql.here are my configurations.</p>
  
  <p><strong>In config/local.js</strong></p>
  
  <pre><code>port: process.env.PORT,
  host: process.env.IP
  </code></pre>
  
  <p><strong>In config/connection.js</strong></p>
  
  <pre><code>mysqlDB:{
    adapter: 'sails-mysql',
    host: '127.0.0.1',
    database: 'custom',
    user:'myname',
    password:'',
    supportBigNumbers:true, //true/false
    module    : 'sails-mysql',
    debug:['ComQueryPacket'], //false or array of node-mysql debug options
    trace:true //true/false
  </code></pre>
  
  <p>}</p>
  
  <p>it gives me this error</p>
  
  <pre><code>{ [Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost'     
  (using password: NO)]
  code: 'ER_ACCESS_DENIED_ERROR',
  errno: 1045,
  sqlState: '28000',
  fatal: true }
  </code></pre>
  
  <p>i can't understand why it is saying user@localhost  while i am expecting it as myname@localhost</p>
  
  <p>thanx for helping me here.</p>