如何远程访问“Infomaniak”数据库服务器

I'm developing a website for some corporation, they hosted a temporary "Coming Soon' version on Infomaniak and they sent me the necessary informations for me to replace that version with the finished website.

I was able to access the FTP thing without a problem but i have no idea on how to use the informations i received to manage the database remotely from my computer (to import my version of the Database).

The Informations I got :

FTP :

  • Host : xxxxx.ftp.infomaniak.com
  • user : xxxxxxxx
  • pass : xxxxxxxxxx

DB :

  • Host : xxxxx.myd.infomaniak.com
  • database : name_of_the_DB
  • user : xxxxxxxxxx
  • pass : xxxxxxxxxxxxxx

It was actually so simple, just use the informations above to login here : https://h2-phpmyadmin.infomaniak.com/index.php

It depends. If you have proper functions for creating DB structure from your app - send files to the server, create connection with that DB and run proper functions to achieve that.

If you are about to login to DBMS and then import your file with DB structure, then use user and password (you just need link to DBMS) and you will be able to do your job from Interface.

If you want to do everything from console, login to the server -> login to the DB and then you can create DB.

You can also use Sequel Pro (on Mac) or MySQLWorkbench (on Windows) and you have all credentials you need so you will have DBMS from which you can easily manage DB.

You can access via Mysql Workbench (https://www.mysql.com/products/workbench/) and use the informations you have.

You can also export/import the database on Workbench.

The Database connection settings can be used to access the database via a MySQL GUI tool (program) such as: MySQL Workbench, Navicat or HeidiSQL. You would also need a connection script for example in PHP to connect to the Database to retrieve and store data in the Database. In this script you need to enter the information about the host, the database name, the user and the password.