How can I connect a remote server from phpmyadmin?

PHP
1

Hello,
I have PhpMyAdmin 2.6.3 , MySQL 4.1.13 running in my Windows 2000.
I installed them using Apache friends XAMPP, so I didn’t do any configuration myself.
Currently if I go to http://127.0.0.1/phpmyadmin, then it automatically shows my local MySQL db and tables.
Now I need to connect remote server(it has MySQL) and do some DB Admin of that server.
How can I connect to that server from phpmyadmin.
I’ve been trying to find if there any kind of connect panel in phpmyadmin, but no fruit yet.

I really appreciate you guys help.

2

The connection information is in phpMyAdmins directory in a file called config.inc.php

3

O.K I created a user named “test” and password “test” in
that server which has all privileges and has access permission from any host. And I modified config.inc.php of my phpmyadmin like this,
$cfg[‘Servers’][$i][‘host’] = '198.53.XXX.XXX;
$cfg[‘Servers’][$i][‘port’] = ‘’;

$cfg[‘Servers’][$i][‘user’] = ‘test’;
$cfg[‘Servers’][$i][‘password’] = test;

But I have the following error as I connect to mysql of that server using phpmyadmin in my computer.
#1045 - Access denied for user ‘pma’@XXX.XXX.XXX.XXX’ (using password: NO)

I didn’t even touch the user ‘pma’ and I don’t know what’s this about.

Somebody can help me?

Thanks.

4

Guess you need to set the rights and permissoins on the mySQL server on ur remote side, or if you dont own it ask the administrator to give you enough privilges to let you connect. As far as i see it user “PMA” is the name of your machine and ur machine has insufficient privileges to access the server. If you own the server you can do it this way

grant all privileges on <DBNAME.TABLENAME> to ‘pma’@‘IP ADDRESS’ identified by ‘PASSWORD’ [with grant option]

you might still not be able to access the server, if there is conflict between the mysql server and client, in which case you need to modify your password to accommodate the old passwords.

set password for user ‘pma’@‘IP ADDRESS’=old_password(‘PASSWORD’);
flush privileges;

Hope its of some help to you !

5