Skip to content

Latest commit

 

History

History
22 lines (18 loc) · 1.24 KB

mysql+tunneling.md

File metadata and controls

22 lines (18 loc) · 1.24 KB

MySQL testing and tunnel to mysql.metropolia.fi

Creating database to mysql.metropolia.fi

  1. Login to https://amme.metropolia.fi/mysql with your metropolia account
  2. Set password for your database. Don't use the same password as your Oma account's password because the database password will be written in plain text to configuration files.

Connecting to graphical UI

  1. Login to https://users.metropolia.fi/phpMyAdmin/ with your Oma username and database password (the one you did in amme.metrpolia.fi/mysql)

Connecting code on localhost to mysql.metropolia.fi

  1. Use vpn
    • this is not possible when using Zoom
  2. Use ssh tunnel
    • Open terminal or powershell
    • run ssh -Ngf -L XXXX:mysql.metropolia.fi:3306 [email protected]
      • replace XXXX with 3306
        • if 3306 is not available on your system use some other port
      • replace username with your Oma username
    • you will be prompted for shell.metropolia.fi password (Oma password)

Connect to mysql.metropolia.fi with express

  1. Use this repo as an example