Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It should have been a simple case of left clicking the WAMPManager menu and clicking <code>Put online</code>.</p> <p>What that would have done is changed this section of <code>httpd.conf</code> from this:</p> <p><em>If using Apache 2.2.x</em></p> <pre><code># onlineoffline tag - don't remove Order Deny,Allow Deny from all Allow from 127.0.0.1 ::1 localhost </code></pre> <p>To this:</p> <pre><code># onlineoffline tag - don't remove Order Allow,Deny Allow from all </code></pre> <p><em>If using Apache 2.4.x</em></p> <pre><code># onlineoffline tag - don't remove Require local </code></pre> <p>To this:</p> <pre><code># onlineoffline tag - don't remove Require all granted </code></pre> <p>And strictly thats all you should have needed to do!</p> <p>But as you have done some manual messing with httpd.conf here are some things you need to check. I am assuming you wanted to change the port to 8080 rather than thinking you had to for some reason. If you didnt want to change port number to 8080 then use 80 in the following info instead of 8080. Changing to 8080 just makes life more complicated for your users, but if this is just a play site that does not really matter I suppose.</p> <p><strong>httpd.conf</strong></p> <pre><code># as your router probably does not support IPV6 change so apache only listens on IPV4 # you dont need to put the actual ip address of this PC in here as you say you did. Listen 0.0.0.0:8080 # ServerName port need to match the Listen, your question made me think you may have left this as localhost:80 ServerName localhost:8080 </code></pre> <p><em>If using Apache 2.2.x</em></p> <pre><code># Assuming your site is in c:\wamp\www ( this section should already exist I just removed all the comments for brevity) &lt;Directory "d:/wamp/www/"&gt; Options Indexes FollowSymLinks AllowOverride all # # Controls who can get stuff from this server. # # onlineoffline tag - don't remove Order Allow,Deny Allow from all &lt;/Directory&gt; </code></pre> <p><em>If using Apache 2.4.x</em></p> <pre><code># Assuming your site is in c:\wamp\www ( this section should already exist I just removed all the comments for brevity) &lt;Directory "d:/wamp/www/"&gt; Options Indexes FollowSymLinks AllowOverride all # # Controls who can get stuff from this server. # # onlineoffline tag - don't remove Require from all &lt;/Directory&gt; </code></pre> <p>If you made the common mistake of changing this section, change it back to this, or you will be giving access to your C:\ to anybody.</p> <p><em>If using Apache 2.2.x</em></p> <pre><code>&lt;Directory /&gt; Options FollowSymLinks AllowOverride None Order Deny,Allow Deny from all &lt;/Directory&gt; </code></pre> <p><em>If using Apache 2.4.x</em></p> <pre><code>&lt;Directory /&gt; Options FollowSymLinks Require all denied &lt;/Directory&gt; </code></pre> <p>I hope something in here makes you stumble upon your mistake or ommission.</p> <p><strong>EDIT: Additional info</strong></p> <p>phpMyAdmin is protected from prying eyes like this:</p> <p>edit c:\wamp\alias\phpmyadmin.conf</p> <pre><code>Alias /phpmyadmin "d:/wamp/apps/phpmyadmin3.5.1/" # 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 # &lt;Directory "d:/wamp/apps/phpmyadmin3.5.1/"&gt; Options Indexes FollowSymLinks MultiViews AllowOverride all Order Deny,Allow Deny from all Allow from 127.0.0.1 &lt;/Directory&gt; </code></pre> <p>See the line <code>Allow from 127.0.0.1</code> that stops anyone not on the same PC as the database using it.</p> <p>So if you are trying to access that from the internet, it wont work.</p> <p>I suppose you could TEMPORARILY change it to :</p> <pre><code>Order Allow,Deny Allow from all </code></pre> <p>Or better still if you know the ip address of where you are going to test it from you coudl do </p> <pre><code>Order Deny,Allow Deny from all Allow from 127.0.0.1 ::1 localhost Allow from xxx.yyy.zzz.aaa </code></pre> <p>Where xxx.yyy.zzz.aaa is your friends IP address.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to bring wamp server online?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRiggsFolly
    1. USRiggsFolly
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to bring wamp server online?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COServerName is changed to <private-ip>:8080 as listen port is <private-ip>:8080; problem is even after implementing suggestions by you (RiggsFolly) i am unable to open phpmyadmin using my public ip. How do i test if my server is online ???
      singulars
      1. PO
      1. USMithilesh
    2. COAny way to test server online ? I tried <my-ip>:8080/phpmyadmin
      singulars
      1. PO
      1. USMithilesh
    3. COphpMyAdmin is protected seperately. You dont want people using that it would make it too easy to hack your site. See my EDIT:
      singulars
      1. PO
      1. USRiggsFolly
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload