Score:0

PHPMyAdmin login with different ip

kp flag

I am trying to login to my phpmyadmin portal with an account created under a certain ip and not localhost. How can i allow that? I have already changed my config file to look like this.

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

And that does not seem to work.

alexus avatar
sa flag
I'd switch that list to `127.0.0.1` and connect to the host via ssh tunnel instead of direct, unless you want to try your luck, then you can switch it to `0.0.0.0` and then there is no IP restriction anymore (not best practice, nor recommended way)..
Jelly Fish avatar
kp flag
Hey thanks for the response. Still triggers this same error when logging in. mysqli_real_connect(): (HY000/1045): Access denied for user 'pterodactyluser'@'localhost' (using password: YES)
alexus avatar
sa flag
make sure your username has correct host in mysql.user that matches your password and privs as well.
Jelly Fish avatar
kp flag
the issue is its trying to login at the localhost ip not 127.0.0.1 which is what the user is created under
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.