How to access phpMyAdmin from local and from Internet

**Paul Brooks** · Jul 17 '05, 12:40 PM

Re: How to access phpMyAdmin from local and from Internet

On Fri, 15 Apr 2005 18:00:07 +0200, "Stefan Mueller"
<seekware-remove-@yahoo.com> wrote:
[color=blue]
>I've just installed phpMyAdmin.
>
>If I have the line
> $cfg['PmaAbsoluteUri '] = 'http://localhost/php/phpmyadmin';
>in my config.inc.php I can login to phpMyAdmin without any problems from my
>local machine. But it's not working from the Internet.[/color]

The comment line says...

* In most cases you can leave this variable empty, as the correct
value
* will be detected automatically.

Look further down in 'config.inc.php ' and you'll see several blocks to
populate the $cfg['servers'] array. If you fill in the values for both
your servers, phpMyAdmin will prompt you to choose server.

Paul Brooks

**Uncle Pirate** · Jul 17 '05, 12:42 PM

Re: How to access phpMyAdmin from local and from Internet

"Stefan Mueller" <seekware-remove-@yahoo.com> wrote in
news:3ca6o9F6lf 3dbU1@uni-berlin.de:
[color=blue]
> I've just installed phpMyAdmin.
>
> If I have the line
> $cfg['PmaAbsoluteUri '] = 'http://localhost/php/phpmyadmin';
> in my config.inc.php I can login to phpMyAdmin without any problems
> from my local machine. But it's not working from the Internet.
>
> To access it from the Internet I have modify the line
> $cfg['PmaAbsoluteUri '] = 'http://www.myserver.co m/php/phpmyadmin';
>
> But now I'm not able to access it from the local machine.[/color]

If you cannot access an internet address from your local PC, it has a
problem with it's setup. Maybe incorrect DNS? A quick easy fix for
that one hostname is to put the server name/IP in your hosts file, but
if you can't access an internet address, you may have a bigger problem
on that machine. Can you access other internet addresses?

--
Stan McCann "Uncle Pirate" http://stanmccann.us/pirate.html
Webmaster/Computer Center Manager, NMSU at Alamogordo
Coordinator, Tularosa Basin Chapter, ABATE of NM; AMA#758681; COBB
'94 1500 Vulcan (now wrecked) :( http://motorcyclefun.org/Dcp_2068c.jpg
A zest for living must include a willingness to die. - R.A. Heinlein

**Stefan Mueller** · Jul 17 '05, 12:43 PM

Re: How to access phpMyAdmin from local and from Internet

Yes, you're right. The behavior of my network is somehow strange, but I
can't change it.
If I do a connection from my internal network to an internet address the
traffic goes to my ZyXEL H650i (ADSL Router) and from there to the internet.
Everything works fine.
If you do a connection from the internet to my server with

http://www.myserver.com/php/phpmyadmin

the traffic also goes to my ZyXEL H650i and is NATted there to my internal
server address.
If I do this connection from my internal network the traffic also goes to my
ZyXEL H650i but is not NATted there to my internal server address.
It seems that my ZyXEL H650i can only do NAT for traffic comming from the
internet to my internal network and not if the traffic is comming from the
LAN side with a WAN address.

Stefan

"Uncle Pirate" <UnclePirate@st anmccann.us> wrote in message
news:Xns963C650 7D7EB2UnclePira testanmccan@216 .234.192.142...[color=blue]
> "Stefan Mueller" <seekware-remove-@yahoo.com> wrote in
> news:3ca6o9F6lf 3dbU1@uni-berlin.de:
>[color=green]
>> I've just installed phpMyAdmin.
>>
>> If I have the line
>> $cfg['PmaAbsoluteUri '] = 'http://localhost/php/phpmyadmin';
>> in my config.inc.php I can login to phpMyAdmin without any problems
>> from my local machine. But it's not working from the Internet.
>>
>> To access it from the Internet I have modify the line
>> $cfg['PmaAbsoluteUri '] = 'http://www.myserver.co m/php/phpmyadmin';
>>
>> But now I'm not able to access it from the local machine.[/color]
>
> If you cannot access an internet address from your local PC, it has a
> problem with it's setup. Maybe incorrect DNS? A quick easy fix for
> that one hostname is to put the server name/IP in your hosts file, but
> if you can't access an internet address, you may have a bigger problem
> on that machine. Can you access other internet addresses?
>
> --
> Stan McCann "Uncle Pirate" http://stanmccann.us/pirate.html
> Webmaster/Computer Center Manager, NMSU at Alamogordo
> Coordinator, Tularosa Basin Chapter, ABATE of NM; AMA#758681; COBB
> '94 1500 Vulcan (now wrecked) :( http://motorcyclefun.org/Dcp_2068c.jpg
> A zest for living must include a willingness to die. - R.A. Heinlein[/color]

**Kees Nuyt** · Sep 24 '05, 08:05 PM

Re: How to access phpMyAdmin from local and from Internet

On Tue, 19 Apr 2005 23:00:57 +0200, "Stefan Mueller"
<seekware-remove-@yahoo.com> wrote:

( Better late than never )
[color=blue]
>Yes, you're right. The behavior of my network is somehow strange, but I
>can't change it.
>If I do a connection from my internal network to an internet address the
>traffic goes to my ZyXEL H650i (ADSL Router) and from there to the internet.
>Everything works fine.
>If you do a connection from the internet to my server with
> http://www.myserver.com/php/phpmyadmin
>the traffic also goes to my ZyXEL H650i and is NATted there to my internal
>server address.
>If I do this connection from my internal network the traffic also goes to my
>ZyXEL H650i but is not NATted there to my internal server address.
>It seems that my ZyXEL H650i can only do NAT for traffic comming from the
>internet to my internal network and not if the traffic is comming from the
>LAN side with a WAN address.[/color]

Try:
ip nat loopback on

If it works, try to insert it in the startup script of the
router, so the command will be executed at every power up and
reset:

sys edit autoexec.net
i (=Insert)
<enter> until you see: wan adsl ...etc
ip nat loopback on<enter>
x (=exit and save)
[color=blue]
>Stefan[/color]

Should work on that ZyXEL ..
--
) Kees Nuyt
(
c[_]

How to access phpMyAdmin from local and from Internet

How to access phpMyAdmin from local and from Internet

Comment

Comment

Comment

Comment