jokulmorder jokulmorder - 1 year ago 102
SQL Question

PHPMyAdmin cannot connect to server

I have installed mysql and am trying to connect with phpmyadmin. When configuring connections in the workbench, I can confirm that this username/password combo exists:

root : [password]

Here is my config:

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Server'][$i]['user'] = 'root';
$cfg['Server'][$i]['password'] = '[password]';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

I set [password] for all users. Additionally, I have tried every possible username for root. Nothing works. Changing the host to be '' does not work. I consistently get this error message back:

1045 - Access denied for user 'root'@'localhost' (using password: NO)


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.

If it helps, I am using IIS8, not Apache.

EDIT: I thought I should mention that all logins have access from %, localhost, or

Answer Source

I think

$cfg['Server'][$i]['user'] = 'root';
$cfg['Server'][$i]['password'] = '[password]';

should be

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '[password]';

Just missing an 's'.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download