Network type: MySQL (TCP/IP). [for MS Sql use MS SQL (TCP/IP)]
Hostname / IP: You use your domain name or your server IP address.
User: Your cPanel username or the database user you created.
Password: Your cPanel password or the password for the database user.
Port: 3306. [1433 for MS SQL] NOTE: These are default ports they can be different
Databases: Leave as Separated by Semicolon.
Startup Script: Leave it blank.
Now you will see the databases and tables on your server.