How to access phpMyAdmin from local and from Internet
Stefan Mueller
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.com/php/phpmyadmin';
But now I'm not able to access it from the local machine.
Is there any solution for my problem?
Stefan
J.O. Aho
multiposter, I never would have replyed, if you have to post the same message
to more than one newsgroup, make a crosspost.
//Aho
Scriptdude
>
>> 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.
Have a look at SQLyog. It allows you to connect to your remote database
via a GUI, even if the remote server uses localhost for the database.
All you have to do is dump the SQLyog PHP file on your remote server and
you can access your databases.
Cool tool.
http://www.webyog.com/sqlyog/index2.php
And no, I'm not affiliated with them :-)
--
Computers will never take the place of books. You can't stand on a
floppy disk to reach a high shelf.
I thought 'Deep Throat' was a movie about a giraffe :/
Scriptdude
bummer, my apologies for wetting your panties before killing the moment.
/me crawls back under his rock
Adam King
Stefan Mueller wrote:
> But now I'm not able to access it from the local machine.
If there is any kind of security on the server (and it was set-up by
someone else) there is probably a firewall preventing access from any IP
other than 127.0.0.1.
Have you tried uploading the code onto your webserver and running the
whole thing from there?
Sorry, if your an expert and that was all obvious to you... I wasn't
sure how expert you were! :-)
Also, while I'm here... I would recommend phpFlashMyAdmin from
www.tufat.com. It's a Flash front end for phpMyAdmin and it rocks!
All the Best...
Adam
Adam King
Ignore what I wrote!
Durrrr...
Kadett
Try to add the www.myserver.com to your hosts file.
ie.
127.0.0.1 localhost
192.168.0.1 www.myserver.com
--
Johan
Stefan Mueller
Thanks a lot for your reply.
Your solution works fine for the described problem but it's not woking if
I'd like to access phpMyAdmin from another computer within the internal
network. Therefore I would have to modify the hosts file of each internal
computer. But if I use my "internal" laptop sometimes from the internet, so
it's not working.
Or am I wrong?
Regards
Stefan
"Kadett" <pt...@hotmail.com> wrote in message
news:Hab8e.134697$dP1.4...@newsc.telia.net...
Kadett
> Hello
>
> Thanks a lot for your reply.
> Your solution works fine for the described problem but it's not woking if
> I'd like to access phpMyAdmin from another computer within the internal
> network. Therefore I would have to modify the hosts file of each internal
> computer. But if I use my "internal" laptop sometimes from the internet, so
> it's not working.
> Or am I wrong?
>
<snip>
The simple way is to edit every computers hosts file, or export the one
you edited, unfortunatly it also means that you can't access it from
Internet w/o removing the lines in the hosts file.
Personaly i have solved the similar problem via a local DNS-server for
my network set as first DNS under my networksettings.
A simplier soloution might be to create a link on the desktop to the
hosts file or might dual hostfiles and a batch-script and just let them
change names by a click.
--
Johan
Stefan Mueller
Many thanks for your help
Stefan
"Kadett" <pt...@hotmail.com> wrote in message
news:Byp8e.22088$d5.1...@newsb.telia.net...