Help Connect Scripts from site with server

[L2OLDPLAYER]

Hello I have a problem because I don't understand something I have a website on xxx.com server I have a script uploaded there to create accounts for the server and now so if I have a server made on my computer on localhost then in the config I give 
     $server_host = 'My IP not localhost ; <---.
    $db_user_name = 'root';
    $db_user_password = '';
    $db_database = 'l2jmobiusclassicinterlude;

but when I want to connect to it the page says : Failed to connect to MySQL: Access denied for user 'root'@'localhost' (using password: NO)

so how to connect it so that the script from the website on another server works with my server and the database which is standing on my computer

[wongerlt]

MySQL remote access.

[L2OLDPLAYER]

12 minutes ago, wongerlt said:

MySQL remote access.

could you elaborate? Add a user with some special accesses? I use Navicat

Edited January 13, 2024 by L2OLDPLAYER

[Nightw0lf]

do not use live connections from the website to your database, better forget it you do less damage

[L2OLDPLAYER]

1 hour ago, Nightw0lf said:

do not use live connections from the website to your database, better forget it you do less damage

So how do I configure this account builder? 

[wongerlt]

3 hours ago, L2OLDPLAYER said:

could you elaborate? Add a user with some special accesses? I use Navicat

Firstly you need change bind-address in mysql config file. Then create another user. There is many guides in google. Keyword `Mysql remote access`.

After all you need configure firewall to allow access only from website.

[L2OLDPLAYER]

16 minutes ago, wongerlt said:

Firstly you need change bind-address in mysql config file. Then create another user. There is many guides in google. Keyword `Mysql remote access`.

After all you need configure firewall to allow access only from website.

I change this in mysql 
# Change here for bind listening
# bind-address="127.0.0.1" 
# bind-address = ::1          # for ipv6
bind-address ="0.0.0.0"

 

and add new user to detabase with all privilages , so now how configure this firewall?

[wongerlt]

18 minutes ago, L2OLDPLAYER said:

I change this in mysql 
# Change here for bind listening
# bind-address="127.0.0.1" 
# bind-address = ::1          # for ipv6
bind-address ="0.0.0.0"

 

and add new user to detabase with all privilages , so now how configure this firewall?

What os?

[L2OLDPLAYER]

It's windows but in fact if I buy vps hosting and put the server there, the website can be on localhost and it will work, right? 

[wongerlt]

3 hours ago, L2OLDPLAYER said:

It's windows but in fact if I buy vps hosting and put the server there, the website can be on localhost and it will work, right? 

What u mean on localhost? On ur pc?

[Nightw0lf]

i have 2 videos for installing a donate panel, some minutes are dedicated to make a secure connection