Issue with server account registration

[denca]

So guys i have a problem with my server account registration website i am using jeutie's blizzlike repack for wotlk 3.3.5a and the website that came with it so i set it up to be public.I dont have a problem making accounts with console but i know i need a website cus i wanna make it public since i already portforwarded the server and everything. my friends ( who are helping me test ) can't make an account here's the error message they get

Database connection failed: Can't connect to MySQL server on '127.0.0.1' (111)

Warning: mysqli::close(): Couldn't fetch mysqli in /srv/disk8/1981158/www/tempest-wow-registration.co.nf/SOAPRegistration.php on line 154

Warning: mysqli::mysqli(): (HY000/2003): Can't connect to MySQL server on '127.0.0.1' (111) in /srv/disk8/1981158/www/tempest-wow-registration.co.nf/SOAPRegistration.php on line 109

Note that i also get that error when trying to make an account

here's the registration website Tempest WoW Account Registration so anyone has a solution to this i'd really be greatful

Edit:
Here's the lines 109 and 154

109: $this -> db = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

154: $this -> db -> close();

[brotalnia]

Are the website and the mysql database on the same machine? If not then that error is really obvious, the registration page is trying to connect to 127.0.0.1 which is the same computer, but there is no mysql there. You have to edit the configuration files and put the correct ip address. Also make sure the name and password are correct.

[denca]

Yeah they're not and i changed it but the issue is when i try to connect with the ip 192.168.x.x ip that i set now its kinda same i even tried using heidisql to try to login to the database to see what happens and it says that tempest-wow.servegame.com ( got that from no-ip thats how everyone connects ) is not allowed to connect to the database

edit:

Even with changed it still says database connection failed help please this is the last thing i need to do to make my server public

[brotalnia]

192.168.x.x is a lan ip address. Unless the machine that is hosting the website is in the same lan network as the database server, it won't be able to connect. You need to type the actual wan address of the database server. To check what it is, type "what is my ip" in Google.

[denca]

Still the same error here's what the config file looks like

// Database settings
define('DB_HOST', '93.180.102.250 ');
define('DB_USER', 'theusername');
define('DB_PASS', 'thepass');
define('DB_NAME', 'auth');

// Soap settings
define('SOAP_IP', '93.180.102.250');
define('SOAP_PORT', '7878');
define('SOAP_USER', 'soapdatabaseacc');
define('SOAP_PASS', 'thepasswordfortheacc');

just pasted in that part but still same issue any other ideas? btw im using biz.nf to host it uploaded the configs to there

[brotalnia]

Are the required ports open on the database server? I think it's 3306 for mysql. If you are hosting on your home pc, is it maybe behind a router? If yes then you would need to forward all the ports to the correct lan ip.

Also this ip 93.180.102.250 is offline for me, can't even ping it. The mysql server has to be online for the registration page to work.

[denca]

Yes all the ports are open because me and 20 of my friends are currently playing on the server i made their accounts with the console and since serve is on apache and mysql are too