Error trying to log into localhost by Phpmyadmin

Asked

Viewed 531 times

0

I am trying to connect to my local database and am getting the following errors:

  1. #1045 - Access denied for user 'root'@'187.20.253.86' (using password: NO)

  2. mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'187.20.253.86' (using password: NO)

I believe it’s because he’s trying to connect to 187.20.253.86 and not to the localhost, but even if that’s the problem, I don’t know how to fix it.

I’m using the Wampserver 3.0.6.

phpmyadmin

  • Local server?

  • Yes, it’s a local server.

  • But if it’s local because it’s using external ip to connect?

  • I don’t know ;-; I lowered the Wamp and it came like this...

  • Any idea how to get back to the localhost? @Articuno

  • How is the file config.inc.php?

  • 1

    I got it, I was looking at the config.sample.inc.php instead of config.inc.php kkkk

  • I’m gonna make an answer to help other people who have the same problem

Show 3 more comments

1 answer

0

Search for the file config.inc.php which probably should be in C:\wamp64\apps\phpmyadmin4.6.4 and open it with some text editor.

Note: Be careful not to confuse with a file called config.sample.inc.php!

Search for the line with these arguments:

$cfg['Servers'][$i]['host'] = '/*OUTRO IP*/';

And change the value to localhost:

$cfg['Servers'][$i]['host'] = 'localhost';

Browser other questions tagged phpmyadmin

You are not signed in. Login or sign up in order to post.