Connection guide for LabraNet database¶

• Use this guide if you are willing to set up a database in to our LabraNet environment
• It is suggested to use this option especially when you are preparing your course exercise in a group and students in this group need to work with the same database

• LabraNet has three options for databases at the moment:

  • MariaDB server (mariadb.labranet.jamk.fi)
  • PostgreSQL server (postgres.labranet.jamk.fi)
  • MySQL server (mysql.labranet.jamk.fi) Important: This database is running older version of MySQL server and will be removed in the near future!

• It is suggested that students will use MariaDB server.

• This server can be utilized for example in course exercise where multiple students in a group may interact and build the same environment.
• Follow this guide in order to prepare your personal database to LabraNet's MariaDB server:
  1. If you are connecting from home, start your VPN connection to the LabraNet (Check LabraNet VPN guide here if needed).
  2. Go to the address https://mariadb.labranet.jamk.fi.
  3. Click the Create Database button.
  4. The system will now generate a new password for your account.
  5. It is suggested that you change this password to something you remember. Change the password by following this guide:
     1. Open MySQL Workbench.
     2. Create a new connection using the following parameters:
        • Connection Name: → Give your connection a new name (for example LabraNet MariaDB)
        • Connection Method: → Standard (TCP/IP)
        • Hostname: → mariadb.labranet.jamk.fi
        • Port: → 3306
        • Username: → Your LabraNet account (for example H1111)
     3. Test your new connection by clicking the Test Connection button.
     4. If your connection test was successful, save the connection by clicking OK button. Otherwise check the connection parameters and that you have VPN connection still enabled.
     5. Connect to LabraNet MariaDB using your new connection settings.
     6. In the query field input the following query:
        • set password=password("new_password") where new_password will be your new password so replace it with the password you prefer.
     7. Run the query with Ctrl + enter keyboard combination.
     8. Your password should now be changed.
  6. You can have four databases in LabraNet's MariaDB server.
     • These databases will be named with your user account (student ID) like in the example below:
       • h1111
       • h1111_1
       • h1111_2
       • h1111_3
     • Create all four databases with the following query (run one query at a time!): create database database_name where database_name is the name of your database (for example create database h1111_2).
     • Now refresh the Schemas view from the Navigator view with refresh button. You should now see all four databases listed.
• Your databases can now be used on any purpose on this course (exercises, course exercise and exam)