Well this case had not been presented to me until now, it turns out that I have an acquaintance who bought a domain (from him) and he has separated a space for me (so to speak) on his server. I have my website hosted, I am just going to start developing what has been the entries (the database is already included).
The problem is that I don't know how to connect to that server. I'm not very experienced in web development as you can see.
With what program or how can I connect to that server with this data? I have: IP address of the server, user, password.
I thought about installing wampserver and phpmyadmin, but I see that it only works locally (unless that is the solution and your configuration changes...)
You can connect with PHP to both local and external databases without problems, just by indicating the IP address of the database (and in some cases the port). The real problem you are going to face is telling the database to accept connections from remote users (shared server databases usually restrict access to only local users).
As you mention, you can use a program like WAMP to have a local server (Apache+PHP) and from there run the PHP code which will connect to the remote database. If you choose this option, it is likely that you will have to send a ticket to the server support (if the server offers support for these cases) asking them to enable the connection of remote users to the database (they will probably ask you for your IP for only unblock the connection from your IP and not for remote users in general).
The other option (and more recommended) is to work directly on the remote server. That is, upload the PHP files to that server and do the programming there. This gives the advantage that you will be connecting to the database as a local user (because the PHP script you upload will be on the same remote server as the database).
You can see a small article that talks about how to connect to a database to retrieve information:
http://blog.aulaformativa.com/connect-php-with-mysql/
Remote connections depend on both parties being generous when working, let me explain. On the server side where the DB you need to access is located, it must allow remote connections, so it normally has to be configured to allow the IP of the computer from which you want to access. Well, now on your side, or the remote client, what you need is access through some handler. I show you an image with Query Browser:
Having the data you claim to have, you can access without problems. All the best.
I share a class to make the connection to the database, this connection is made through php :
To use it, you create the class object and call the function you need by sending the query, there it tells you that each function returns, I leave you an example:
I hope it helps you