title: CakePHP 2 is not able to connect to MySQL database
body: <p>Using the latest CakePHP 2.0 RC3, I am trying to connect to MySQL database.
  For this, I changed the database.php file present in the app/config directory.</p>
  
  <p>The file contains the below details required for connecting to the database.</p>
  
  <pre><code>class DATABASE_CONFIG {
  
         public $default = array(
          'datasource' =&gt; 'Database/Mysql',
          'persistent' =&gt; false,
          'host' =&gt; 'localhost',
          'login' =&gt; 'root',
          'password' =&gt; '',
          'database' =&gt; 'db_world',
          'prefix' =&gt; ''
         );
  
  }
  </code></pre>
  
  <p>For root, I tried both by setting the password as well as using a blank password.</p>
  
  <ul>
  <li>Tried using the 'root' user as well as by creating another user with the required privileges.</li>
  <li>Tried giving 127.0.0.1 in place of 'localhost'</li>
  <li>Checked that the database was getting connected using normal php script.</li>
  </ul>
  
  <p>The normal php script to test database connectivity is like:-</p>
  
  <pre><code>&lt;?php
  
     $connect = mysql_connect("127.0.0.1","root","") or die("Could not connect");
     mysql_select_db("db_world") or die("Could not find db");
  
     echo "hello world";
  
  ?&gt;
  </code></pre>
  
  <p>The above script works which means that it is not an issue from MySQL side.</p>
  
  <p>Still I always get "Cake is not able to connect to database".
  Currently I am not sure what I am missing here.</p>
  
  <p>Any pointers to fix the issue will be helpful.</p>