Accessinging phpmyadmin through network

[woodburndesigns]

Hello All,

I recently download wamp to my desktop. I would like to be able to access phpmyadmin via my laptop which is on the same network as the desktop. I was able to gain access to the webroot folder by configuring the httpd.config file but I can't gain access to to phpmyadmin. I tried adding a user with the host name being my laptops IP but that hasn't worked.

Is there anything that you guys could suggest that might help me out? Do I have to rename to host from localhost to the desktops ip?

PS I am currently trying to access phpmyadmin from my laptop by adding the url:

192.168.1.100/phpmyadmin

to the browser.

[NogDog]

You should be able to use "localhost" for the host name.

Check the [wamp-directory]/phpmyadmin/config.inc.php file. Look for the "Authentication Method" section. I use the following options:

$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = '';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'config' auth_type)

Then when you access phpmyadmin you should get a log-in window, where the user name and password are whatever MySQL user you want to use.

[halojoy]

you should setup an alias Directory
in httpd.conf
Unless you have /phpmyadmin/ installed in your /htdocs/ root
..... which is not a good idea - put it outside you /htdocs/
( there are hacker bot programs trying to access /phpmyadmin/ to any webserver
I have seen this many times in my Apache access.log )

This alias directory should have:
Deny from all
Allow from 'your local IP'

it is a good idea to use some other name for this directory,
than /phpmyadmin/

About logging in to phpmyadmin
you should edit:
'config.inc.php' in phpmyadmin root
phpmyadmin has good config Instructions at their homepage

I know this, as I very recently upgraded to latest phpMyAdmin version

[woodburndesigns]

Thank you so much for your response. I went ahead an made the changes you recommended and I do get the username and password prompt when opening phpmyadmin from my desktop.

However, when trying to access from my laptop I am still getting the error:

Forbidden
You do not have permission to access /phpmyadmin/index.php on this server.

Do I need to change something else in the httpd.config file to allow access to that folder?

[woodburndesigns]

Ok, so I've added:

<Directory "C:/Program Files/wamp/phpmyadmin">
Deny from all
Allow from 192.168.1.101
</Directory>

to the httpd.config file.

and changed the auth type to http in the config.inc.php file but it is still saying Forbidden. I must be doing something wrong. Could the problem lie within my network by chance?

Thanks for all your help!

[NogDog]

The "localhost" IP is 127.0.0.1 (not your Internet IP address).

My installation of WAMP has the following line at the end of the httpd.conf file:

Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"

That file consists of:

Alias /phpmyadmin/ "c:/wamp/phpmyadmin/" 

# to give access to phpmyadmin from outside 
# replace the lines
#
#        Order Deny,Allow
#	Deny from all
#	Allow from 127.0.0.1
#
# by
#
#        Order Allow,Deny 
#   Allow from all
#

<Directory "c:/wamp/phpmyadmin/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
	Deny from all
	Allow from 127.0.0.1
</Directory>

I am then able to access phpMyAdmin with the following URL:

http://localhost/phpmyadmin/