I just got a VPS and bought a cheap domain
I put my website from another provider, and brought it over to this one.
Issue is, when I try to connect to mysql through PHP I get
Access denied for user ‘user’@’[Unknown]’ (using password: YES)
(It doesn’t say unknown – i can see it; Its actually someone else’s domain I’ve never heard of and to protect their identity i didn’t show it)
Thing is, I’ve never even heard of that domain, never mind tried to connect to it. When connecting i use
new mysqli(“mysql.[MY DOMAIN]”, $username, $password, $dbname)
Of course i know my username and password are correct. I have double, and triple checked. I can log in manually through my browser, and through an SSH terminal
My best guess is the domain never propagated. So I checked it. I pinged the site from the host, from my computer, and even checked 3rd party sites – all say it has been properly propagated. And it have been almost 5hrs since I set all this up
Google doesn’t return a lot of results. my best guess is when MySQL does its reverse DNS look up, the copy on the server is out of date – but I have a VPS so there’s nothing I can do about that.
At this point i’m ready to pull my hair out; has anyone else had any issues like this?
Edit: Also worth noting: The Domain mysql is trying to connect to also actually exists; but I don’t associate with it in anyway.