Only localhost can access phpMyAdmin

[Sizaro]

How can I make so only localhost can access phpMyAdmin? <_<

 

[MrSheen]

When you set the usernames in phpmyadmin, you set the username 'host' to localhost. That way only that user can connect via localhost.

 

[EvulMastah]

How can I make so only localhost can access phpMyAdmin? <_<

Add below <?php in phpmyadmin/index.php:

    if($_SERVER['REMOTE_ADDR'] != '127.0.0.1')
        exit(-1);

 

[Sizaro]

Now when I try to access it (From another computer) I just get nothing It's a white window Is it possible to make so 2 other ips can connect?

 

[Feloth]

Change it to this:

if($_SERVER['REMOTE_ADDR'] != '127.0.0.1' AND $_SERVER['REMOTE_ADDR'] != '##IP OF ONE COMPUTER##' AND $_SERVER['REMOTE_ADDR'] != '##IP OF SECOND COMPUTER##')
        exit(-1);

If you want 3 ips, you just add a AND $_SERVER['REMOTE_ADDR'] != '##IP OF COMPUTER##'
You get the drill ;D

 

[Sizaro]

Thanks

 

[Feloth]

Wrong info...

 

[Sizaro]

It did work ;o?

 

[Feloth]

Wrong info.. read further..

 

[Sizaro]

Haha is it possible to make so theres a text if you're not the localhost or the other ips? Like

A random guy do: wofb.mine.nu/phpmyadmin
then:

HAHA JUST TRY NOOBAK! JULL NEVAH GET INTA DA DATABASEEEE MOAHAHAHHA!

 

[Feloth]

Yeah!

if($_SERVER['REMOTE_ADDR'] != '127.0.0.1' AND $_SERVER['REMOTE_ADDR'] != '##IP OF ONE COMPUTER##' AND $_SERVER['REMOTE_ADDR'] != '##IP OF SECOND COMPUTER##') {
    echo "Fuck you! Hope you die irl noob.";
    exit(-1);
}

Just change the text in there.

 

[Sizaro]

Now I can't access from the my again xDDD'
Dosent work when I change AND to OR

 

[Feloth]

What does it say?

 

[Feloth]

Parse error: parse error, expecting `','' or `';'' in C:\xampp\phpMyAdmin\index.php on line 3

lol, im updating here..

Make sure you have the ; in the end on line 3

 

[Sizaro]

<?php if($_SERVER['REMOTE_ADDR'] != '127.0.0.1' AND S_SERVER ['REMOTE ADDR'] != 'myip:P')
echo "Hi";
exit (1-);

That's my code.

 

[Feloth]

LOL

Because S_SERVER is not a variable xD $_SERVER is..
And dont remove the { and }

   <?php if($_SERVER['REMOTE_ADDR'] != '127.0.0.1' AND $_SERVER['REMOTE ADDR'] != 'myip:P') {
echo "Hi";
exit (1-);
}

 

[Sizaro]

Okay, just need to test now

 

[Feloth]

Dont remove the { and }
Only time you never use { and } is when your code is on a single line.

Example when not to use { and }

if($noob == true)
echo "Noob";

Example when to use { and }

if($noob == true) {
echo "Noob";
echo "HEHEEH";
}

 

[Feloth]

And you are not able to view the page?
Does it show you the text? Try using this:

$myip = $_SERVER['REMOTE_ADDR'];
if($myip != '127.0.0.1' AND $myip != 'YOUR IP') {
  echo "You are not able to access this site, IP: ".$myip;
  exit(-1);
}

And tell me if it shows the IP that you have written in for yourself.

 

[Sizaro]

Is there anything I can do to store the ip if someone tries to enter?
Like

   <?php if($_SERVER['REMOTE_ADDR'] != '127.0.0.1' AND $_SERVER['REMOTE ADDR'] != 'myip:P') {
echo "Yo! You're ip (IP) has tried to access wofb.mine.nu/phpmyadmin you're ip is now stored in our database and all you're accounts and characters will now get deleted (joking). xD";
exit (1-);
}

or this

<?php
$a = 10;
while ($a < 100) {
echo ' DIE! <br \> ';
}
?>