title: mysql said: Cannot connect: invalid settings. xampp
body: <p>I changed the root password to test and now I cannot login in phpMyAdmin page in XAMPP. I looked for help <a href="http://rudyegenias.wordpress.com/2006/09/15/enabling-phpmyadmin-once-you-change-permission-or-privileges-on-mysql-database/" rel="noreferrer">here</a> and <a href="http://www.apachefriends.org/f/viewtopic.php?f=16&amp;t=30459" rel="noreferrer">here</a> which basically says changed <strong>config.inc.php</strong> file in <strong>XAMPP\PHPMYADMIN</strong> folder.</p>
  
  <pre><code>/* Authentication type and info */
  $cfg['Servers'][$i]['auth_type'] = 'config';
  $cfg['Servers'][$i]['host'] = 'localhost';
  $cfg['Servers'][$i]['connect_type'] = 'tcp';
  $cfg['Servers'][$i]['compress'] = false;
  $cfg['Servers'][$i]['user'] = 'root';
  $cfg['Servers'][$i]['password'] = 'test';    &lt;---- changed this
  $cfg['Servers'][$i]['extension'] = 'mysql';
  $cfg['Servers'][$i]['AllowNoPassword'] = true;
  
  /* User for advanced features */
  $cfg['Servers'][$i]['controluser'] = 'pma';
  $cfg['Servers'][$i]['controlpass'] = 'test'; &lt;--- I changed this too (Edit: Not needed)
  </code></pre>
  
  <p>This code below works which uses the above password</p>
  
  <pre><code>if($_SERVER['REMOTE_ADDR']=="127.0.0.1")
  {
  define("DATABASE_SERVER", "localhost");
  define("DATABASE_USERNAME", "root");
  define("DATABASE_PASSWORD", "test");
  define("DATABASE_NAME", "TIGERWOODS");
  } 
  </code></pre>
  
  <p>This happend to me bofore on Mac and I could not resolve it. Now it happened again on WinXP. I am using Xampp 1.7.4.</p>