Apache Friends Support Forum

I am unable to access a remote Mysql server from phpMyAdmin. It seems that I can connect to it with another system running XAMPP.

I'm getting a error:
#2000 Cannot log in to the MySQL server

It doesn't seem to be an issue with the firewall.

From what i'm understanding the problem exists with the root account and it's password. Did you try to set the root password?

Code: Select all

//$cfg['Servers'][$i]['controluser'] = 'root';
 //$cfg['Servers'][$i]['controlpass'] = 'Arthur01';


Another solution can be setting the PHPMyadmin extention up to use mysqli instead of mysql. You should do this in the config.inc.php file in phpmyadmin.

Code: Select all

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';