I have 2 VPS servers for my website. One is meant for storing the database, and the other one is meant for as a file server for the website. Now the VPS server with the website needs to connect to the VPS server which contains the database.
I already created a domain on the website VPS, which has the files of the website stored on it. Now, this needs to connect with the VPS server which holds the database. I already opened the port 3306 on this database server. Now, I only created the database in the PhpMyAdmin of this webserver, so I didn't make a domain on it.
Now, how can I reach the database from the VPS which is containing the website? Which hostname, username and password should I use to connect to the MySQL settings of the database server?
I already created a domain on the website VPS, which has the files of the website stored on it. Now, this needs to connect with the VPS server which holds the database. I already opened the port 3306 on this database server. Now, I only created the database in the PhpMyAdmin of this webserver, so I didn't make a domain on it.
Now, how can I reach the database from the VPS which is containing the website? Which hostname, username and password should I use to connect to the MySQL settings of the database server?
