How to transfer database from old host to Digitalocean

Hello,

I am currently having a wordpress website at cloudways and I want to migrate to digitalocean. I successfully installed wordpress using easyengine (nginx) and I transferred wp-content to the new server here.

I am stuck at migrating the database. As I can understand the default location for databases is at /var/lib/mysql. How can I transfer my old database here using an .sql or .sql.gp file?

I used this command mysql -h localhost -u xtmdntvrds -p xtmdntvrds < xtmdntvrds.sql but when I insert password it gives me ERROR 1045 (28000): Access denied for user 'xtmdntvrds'@'localhost' (using password: YES)

The password is correct for sure because I can see it in wp-config.php file.