title: Use local phpMyAdmin to connect to remote database through Xampp
body: <p>I'm a beginner so please bear with me. </p>
  
  <p>I wish to access and work on client remote database server from localhost using phpMyAdmin Xampp. From what I search online, I know I need to change the code in file config.inc.php as shown below.</p>
  
  <pre><code>$i++;
  /* Server parameters */
  $cfg['Servers'][$i]['host'] = '';                       //server host name or IP
  $cfg['Servers'][$i]['connect_type'] = 'tcp';            
  $cfg['Servers'][$i]['compress'] = false;
  $cfg['Servers'][$i]['AllowNoPassword'] = false;
  $cfg['Servers'][$i]['user'] = '';                       //Account username
  $cfg['Servers'][$i]['password'] = '';                   //Account password
  $cfg['Servers'][$i]['auth_type'] = 'config';
  </code></pre>
  
  <p>But after I changed I got some error messages.</p>
  
  <pre><code>#1045 - Access denied for user (using password: YES) 
  
  Connection for controluser as defined in your configuration failed.
  
  phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
  </code></pre>
  
  <p>I have gone through similar cases and found that I should create a new user in the database. But I got another errors after changed.</p>
  
  <pre><code>#1129 - Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 
  
  Connection for controluser as defined in your configuration failed.
  
  phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
  </code></pre>
  
  <p>I have no idea how to solve this problem and was hoping that some of you could provide me with some advice. Thanks.</p>
  
  <p>Sorry for my poor English.</p>