For importing large databases we recommend using tools such as MySQL Workbench.
Before being able to connect remotely you will have to:
- Create a database and assign a username with full privileges to it;
- Add your IP address in the allowed IPs to access the MySQL service.
All of the above can be done via the MySQL section in cPanel. For detailed instructions how to perform those steps check siteground mysql tutorial.
cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!
