Well, just a little bit of help needed. I am hosting a game server from my VPS and I’m using the VPS’s MySQL to store player’s data. Now I want to access it through my website, but the table i want to display is blank. And I’m hosting the website using Infinity Free as I want the website to run even if the VPS ends. Please help.
Well, By default, MySQL system is not listening for external connections.And to enable external connection you might add some settings to your MYSQL server in your VPS
If you’ve configured it already, then there might be an issue with your codes.
If you use MySQL, Edit the /mysql.cnf file, If not edit the mariadb.cnf file, And change the
bind-addressFrom 127.0.0.1, To 0.0.0.0 to listen on all interfaces, and when creating a user, Instead of
root@localhost
Which makes the root user ONLY accesible through localhost, use
root@%
Which makes root listen on all interfaces.
If you need more help, Feel free to PM me.
I get what you guys are saying, but I later tried using the epizy MySQL to be accessed remotely that too doesn’t happen… And I have my MySQL configured properly as I am already accessing it remotely through my PC too.
uhh . nevermind i’ll look up for something else
This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.