TCP/IP

To create and manage MySQL databases only over the command line can be quite challenging. You may know to the browser-based tool “phpMyAdmin”, but this tool has some limitations (e.g. no visual data base design)
To overcome this problem, you can download the MySQL Workbench from https://www.mysql.com/de/products/workbench
Install the program, start it and add your database credentials using the plus right to “MySQL Connections”. Caution, maybe not every database can be accessed directly throw the internet, many databases listen only to localhost for security reasons. If this is the case, use Standard TCP/IP over SSH to let MySQL Workbench to create an SSH tunnel for you.
Now you can use the MySQL Workbench to create and manage your databases.