Nobody ever really wants to move a database, but it is a frequent necessity. Here are the most common options and when to use each one ...

Use this guide to learn how to easily create and manage a MySQL 8 user with remote access to all databases.

You don't necessarily <B>have</B> to have root access to the MySQL server, but you should at least have an account with insert/update/etc. permissions on the database you're going to be importing ...