How can I connect to my database from my local workstation?

I need to import data into my database from a local file. How can I do that from my local workstation?

For that you can use the Platform CLI tool and run platform sql < my_local.sql. More information can be found on our docs site.

never worked with host 127.0.0.1 port 30000

here are the creds i used

<?php $conf['dblayer'] = 'mysqli'; $conf['db_base'] = 'main'; $conf['db_user'] = 'user'; $conf['db_password'] = ''; $conf['db_host'] = 'database.internal';