Hey, I was trying to figure out how I can add a whitelisted ip address on my database so I can have sonorancad access it to sync character databases over to Sonorancad automatically. I’ve tried looking for the answer myself but I haven’t found out how to do it yet. I am fairly new to this and hoping to find out how to do this.
phpMyAdmin is not your database, it is tool to manage your database.
MySQL access control limits users by hosts, so you need to grant their IP address access to the user. You need to also make sure your MySQL is listening on all interfaces, and you allowed their IP in your firewall to access your database on port 3306.
Generally this could be a security risk, so it would be better if they provide a resource to sync characters.
Ya, I unlocked the port on my firewall but I get this error. So I’m still trying to figure out the file I edit and what line I have to edit to allow access.
You don’t have permission to access this resource.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 Server at 135.148.138.134 Port 443