We do not offer an FTP service by default on any of our droplets as the protocol is insecure. Instead, all droplets have an SFTP service enabled.
When you create a droplet a “root” user account with full administrative privileges is created. If you are using password based authentication, your password is emailed to you and you are required to change it the first time you log in.
Once you create a droplet (server) on our platform we have no access to it, or your password. You can reset your password for any of your droplets via the control panel.
This guide will walk you through using Filezilla to connect to your droplet’s SFTP service.
By “database file” I assume that you’re referring to a .sql format export of your database. Please correct me if I am wrong. If this is the case, you will have to use the mysqldump utility over ssh in order to export your database as a .sql file. If you have phpmyadmin installed on your droplet you can perform an export via a browser by accessing phpmyadmin.
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to import and export MySQL databases and how to reset a root MySQL password