title: trying to load tables into my database using vagrant
body: <p>I'm using Vagrant to start a VirtualBox VM in windows. I do:</p>
  
  <p><code>$ vagrant ssh</code></p>
  
  <p>To connect to the VM. Then I do <code>$ mysql</code> to connect to my database. Then I can see my DB that I have created to use. However When I go to my server I see this error:</p>
  
  <pre><code>The table "doe_user" for active record class "User" cannot be found in the database.
  </code></pre>
  
  <p>I know thats because the database is empty and the table User doesnt exist. thats why I tried to added tables to database using this :</p>
  
  <pre><code>load all tables in the doe_db:        http://***.***.**.**/install.php;
  </code></pre>
  
  <p>When  I run this, i get:</p>
  
  <pre><code>mysql&gt; load all tables in the doe_db:     http://***.***.**.**/install.php;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
  corresponds to your MySQL server version for the right syntax to use near 'all t
  ables in the doe_db:     http://***.***.**.**/install.php' at line 1,
  </code></pre>
  
  <p>when I use <code>show databases</code> then I select the correct database, then asking to show the tables it returns empty set. </p>
  
  <p>when I go to my <code>http://***.***.**.**/install.php</code> I get:</p>
  
  <blockquote>
  <pre><code>Internal Server Error
  
  Undefined index: log
  
  An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
  
  Thank you.
  </code></pre>
  </blockquote>
  
  <p>Here is my database code:</p>
  
  <pre><code>$config_database = array(
          'components' =&gt; array(
                  'db' =&gt; array(
                          'connectionString'   =&gt; 'mysql:host=localhost;dbname=doe_db',
                          'emulatePrepare'     =&gt; true,
                          'username'           =&gt; 'root',
                          'password'           =&gt; 'root',
                          'charset'            =&gt; 'utf8',
                          'enableProfiling'    =&gt; true, //http://www.yiiframework.com/doc/guide/1.1/en/topics.logging
                          'enableParamLogging' =&gt; true,
                  ),
          ),
  );
  </code></pre>
  
  <p>Now when I visit: <code>http://***.***.**.**/index.php</code></p>
  
  <p>I get the error:</p>
  
  <pre><code>The table "doe_user" for active record class "User" cannot be found in
  the database.
  </code></pre>
  
  <p>However when I change my databse code to:</p>
  
  <pre><code>$config_database = array(
          'components' =&gt; array(
                  'db' =&gt; array(
                          'connectionString'   =&gt; 'mysql:host=localhost;dbname=doe_db',
                          'emulatePrepare'     =&gt; true,
                          'username'           =&gt; 'root',
                          'password'           =&gt; '',
                          'charset'            =&gt; 'utf8',
                          'enableProfiling'    =&gt; true, //http://www.yiiframework.com/doc/guide/1.1/en/topics.logging
                          'enableParamLogging' =&gt; true,
                  ),
          ),
  );
  </code></pre>
  
  <p>And when I visit: <code>http://***.***.**.**/index.php</code>I get:</p>
  
  <pre><code>CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)
  </code></pre>
  
  <p>for my local host, when I want to access phpMyAdmin, I dont have any password for my root user.</p>