Unable to access remote Mysql Server from phpMyAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unable to access remote Mysql Server from phpMyAdmin

Postby henrycanvas » 11. March 2011 19:16

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.
henrycanvas
 
Posts: 1
Joined: 11. March 2011 19:13

Re: Unable to access remote Mysql Server from phpMyAdmin

Postby DC80 » 12. March 2011 13:16

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';
DC80
 
Posts: 24
Joined: 11. March 2011 13:35
Operating System: Linux Mint 12 (lisa)


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 118 guests