Regarding the connection between an FTP Server and a Database Server

Question

Good day, to make a long story short I was given access to an FTP server in order to upload files to an online website using FileZilla and was given the following:

• FTP Username
• FTP Password
• FTP Server
• Port Number

When I tried to asked our "consultant" about access to details to connect to a database server, I was told that I should know how to get in since I was given FTP server access.

However when I downloaded MySQL Workbench to try and edit the database, the the details (or parameters) are different to what I was given to access the FTP.

I would just like to know if I could access the database using FTP credentials or if both need completely separate details to connect. Thanks for any help/advice.

FTP (FileZilla):

SQL (MySQL Workbench):

EDIT:

I use xampp in order to edit an offline version of the database to test before I upload new code into filezilla. I added new columns with ease offline but It does not show online.

For more information:

• I have another person editing database info on the online website
• The offline version information is completely different and does not update.
• I have added a new column in the offline database but there is no update on the website's online version.
• This means that there is an online database that I cannot access since I do not have credentials.

Answer 1

FTP and database accesses are two completely different and unrelated things.

While it is possible that hostname, username and password might be the same for both (while still technically separate), port number must be different.

Maybe you are not supposed to have a database access. It may not be available remotely. Maybe only the server-side scripts can access the database (locally – on the server).