phpMyAdmin logs out each time my IP changes

[GoWilkes]

I'm trying to start using my mobile hotspot for home internet instead of DSL, because (a) it's paid for, (b) it's cheaper, and (c) it's about 5 times faster! But I'm coming across a few tiny little nuisances that I'm trying to eliminate one by one.

I usually keep a few Chrome tabs pinned with PMA so that I can look something up in one tab and then use the info to insert or select in the second tab. I rely on these tabs pretty heavily.

What I've found, though, is that when I take my phone with me and then come back, the hotspot reconnects with a different IP. Then PMA gives me an error, so I have to copy my old query, refresh the page, then log back in and paste my query back in. This happens 2 or 3 times a day, so it's not a tragedy... just annoying and a small time waster.

Is there a way that I can get PMA to stop doing that, and just leave me logged in?

 

[cPanelLauren]

Probably not but you'd need to discuss this with the provider themselves. I don't know that they'd be able to provide you a static IP though.

 

[GoWilkes]

Probably not, I've never been able to get past a Level 1 tech that's just reading canned responses from their computer :-( I was hoping there was a way on cPanel/PMA's end that I could just make it stop looking at the IP, though... oh well

 

[cPanelLauren]

We can't control the IP your device is using for the hotspot, unfortunately. I'm sorry.

 

[GoWilkes]

Haha, of course not! LOL I was just hoping there could be a way to make the program stop looking for the IP entirely.

I can imagine that I'm not the only person that would like this. Imagine small business owners that travel a lot and use their hotspot while they're on the road... using PMA would be next to impossible! There should be a way to lessen security and just allow a simple cookie or something. It shouldn't be the default, of course, but for those of us that need it, the option should be there.

 

[cPanelLauren]

Yea, I feel like it would be really valuable. As far as CookieIP validation - actually that might work but I'm not 100% for PHPMyAdmin - You can check the setting in WHM>>Service Configuration>>Tweak Settings - > Cookie IP validation
Validate the IP addresses used in all cookie-based logins. This will limit the ability of attackers who capture cPanel session cookies to use them in an exploit of the cPanel or WebHost Manager interfaces. For this setting to have maximum effectiveness, proxydomains should also be disabled. Strict validation requires the current IP address and the cookie IP address to exactly match. Loose validation only requires they are in the same /24.

I didn't even think about it for anything besides cPanel specifically - you could give it a shot though.