0

I tried to access phpMyAdmin but I get an error.

Cannot connect: invalid settings.
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.

  • Can you access the MySQL server with the credentials you are trying to use in PHPMyAdmin? – Tero Kilkanen Aug 31 '14 at 21:01
  • 2
    I think that the phrase "You should check the host, username and password in your configuration " is a good clue to what might be the problem. – Steve Aug 31 '14 at 22:26
  • As Steve says. Check with your web host as to the format/type of credentials that are expected. – MrWhite Sep 1 '14 at 13:58
1

Are you have start the phpmyadmin service ? If you are using xampp, check the phpmyadmin configuration:

  1. C:\xampp\phpMyAdmin
  2. open and edit config.inc.php with your text editor

Look at this line:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

In this configuration, the username is "root" and password is empty, hosted on 127.0.0.1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.