Hello, we are getting ready to do a site redesign but I want to use the same data stored in my SQL VPS. We have a production environment setup using XAMPP, but when I try to connect to my dreamhost SQL VPS I get an error.
Warning: mysqli::mysqli(): (HY000/1130): Host ‘MY.IP.ADD.RESS’ is not allowed to connect to this MySQL server in C:\xampp\htdocs\dbconnect.php on line 2
How can I give my IP address permission to access the SQL server?
All instructions online deal with having a shell user and from what I can tell I can’t get a shell user on my SQL VPS?
Answering my own question…
It was just hard to find