log into phpmyadmin from pc not server

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

log into phpmyadmin from pc not server

Postby MarkK » 08. June 2018 13:48

I'd like to log into the phpmyadmin database from my desk pc, not the server where the database is located. I get the following error:

New XAMPP security concept:

Access to the requested directory is only available from the local network.

This setting can be configured in the file "httpd-xampp.conf".

Here is the block I believe I need to modify in the httpd-xammp.conf file:

Alias /phpmyadmin "E:/Engineering/Database/phpMyAdmin/"
<Directory "E:/Engineering/Database/phpMyAdmin">
AllowOverride AuthConfig
Require local
Require ip 192.168.0.22
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</Directory>

If someone could kindly tell me what to change, assuming I found the block I need to change, that would be greatly appreciated.

Will I need to stop and restart the Apache service in order for the changes to take effect?

Thanks

Mark
MarkK
 
Posts: 9
Joined: 20. April 2018 13:52
XAMPP version: v3.2.2
Operating System: Windows

Re: log into phpmyadmin from pc not server

Postby TonyVier » 08. June 2018 13:54

Remove "require local"..
TonyVier
 
Posts: 43
Joined: 24. May 2018 11:22
XAMPP version: 7.2.5-0
Operating System: Windows 10 pro

Re: log into phpmyadmin from pc not server

Postby Nobbie » 08. June 2018 14:01

TonyVier wrote:Remove "require local"..


.. and also remove "Require ip 192.168.0.22" (whoever did that, thats not default configuration).

Will I need to stop and restart the Apache service in order for the changes to take effect?


Yes.
Nobbie
 
Posts: 10509
Joined: 09. March 2008 13:04

Re: log into phpmyadmin from pc not server

Postby MarkK » 21. June 2018 14:07

I will give this a try.

Thanks

Mark
MarkK
 
Posts: 9
Joined: 20. April 2018 13:52
XAMPP version: v3.2.2
Operating System: Windows

Re: log into phpmyadmin from pc not server

Postby gsmith » 21. June 2018 20:13

Nobbie wrote:
TonyVier wrote:Remove "require local"..

.. and also remove "Require ip 192.168.0.22" (whoever did that, thats not default configuration).


Just curious, did you read the question? He does not want the "default" config.

If he removes require local, only 192.168.0.22 can access phpmyadmin (what he wants). If he also removes that require ip as you suggest, nothing can access it. Same as require all denied.
gsmith
 
Posts: 237
Joined: 29. November 2013 18:04
Location: San Diego
XAMPP version: 0.0.0
Operating System: Win 7-10/VC 6,9,11,14,15

Re: log into phpmyadmin from pc not server

Postby Nobbie » 22. June 2018 11:20

gsmith wrote:Just curious, did you read the question?


Of course, and he asked this question:

Here is the block I believe I need to modify in the httpd-xammp.conf file:


If he suspects that he has to adjust this block, then I assume of course that he neither knows what he is doing nor that he has already done anything.

gsmith wrote:If he removes require local, only 192.168.0.22 can access phpmyadmin (what he wants).


How do you know anything about that IP? And what if the Desktop PC is assigned a dynamic IP via DHCP, what is very common in LANs? Especially when he is still unsure if this is the right block to customize? That's why I was so surprised how this line got there? Why doesn't he add that?

ALso if so, then you should either ask if this IP is the right IP and it is static, or recommend the correct Require clause for that LAN, namely "Require 192.168.0".

Either way, I cannot see how this line got there and we have not received an answer to date. But you can save yourself the stupid question of whether I would have read the question.
Nobbie
 
Posts: 10509
Joined: 09. March 2008 13:04

Re: log into phpmyadmin from pc not server

Postby MarkK » 25. June 2018 19:26

OK, after reading all the replies, I believe I can leave 'require local' as is, and change the ip to '192.168.0' , and this will allow any pc on the lan to access the database, which is what I want. 192.168.0.22 is the static ip of the server, pc's on the lan get a new ip each day. I want to be able to access/view the phpmyadmin page from any pc on the lan (it is behind a password).

I have not tried this yet.
MarkK
 
Posts: 9
Joined: 20. April 2018 13:52
XAMPP version: v3.2.2
Operating System: Windows

Re: log into phpmyadmin from pc not server

Postby Nobbie » 25. June 2018 20:50

MarkK wrote:192.168.0.22 is the static ip of the server


@gsmith: oops, how embarrassing....
Nobbie
 
Posts: 10509
Joined: 09. March 2008 13:04

Re: log into phpmyadmin from pc not server

Postby MarkK » 26. June 2018 13:26

Got her done, thanks.

Mark
MarkK
 
Posts: 9
Joined: 20. April 2018 13:52
XAMPP version: v3.2.2
Operating System: Windows

Re: log into phpmyadmin from pc not server

Postby gsmith » 02. July 2018 18:45

Not really, I just assumed (incorrectly yes) he had given the right IP for the computer he wanted to access it. It sounded as if he wanted access from just the one, not the entire lan or the server itself.

I'd like to log into the phpmyadmin database from my desk pc, not the server where the database is located.
gsmith
 
Posts: 237
Joined: 29. November 2013 18:04
Location: San Diego
XAMPP version: 0.0.0
Operating System: Win 7-10/VC 6,9,11,14,15

Re: log into phpmyadmin from pc not server

Postby Nobbie » 02. July 2018 19:54

gsmith wrote:Not really, I just assumed (incorrectly yes) he had given the right IP for the computer he wanted to access it. It sounded as if he wanted access from just the one, not the entire lan or the server itself.


Even if he wants to access from just "the one", just "the one" would not have a static IP:

pc's on the lan get a new ip each day


That already requires to apply a range instead of a single IP. As already said.
Nobbie
 
Posts: 10509
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 23 guests