OPIM MariaDB Connection Setup

Owned by Christopher Zissis, created
Last updated: Feb 06, 2024
4 min read

Some OPIM/MIS courses require setting up a connection to a MariaDB database that is managed by the School of Business IT department. Your professor will tell you if this is a requirement for your course.

Accounts for the MariaDB server are typically created after the add/drop period. Student MariaDB accounts are deleted after each semester’s grades are finalized.

Who is this guide for?

 

  • Students enrolled in specific OPIM/BADM courses that require access to a MariaDB database

  • Faculty who teach classes requiring MariaDB access

  • Teaching Assistants or Grad students assisting with a class using the MariaDB server

Requirements

  • Internet access

    • When on a UConn campus you must use UCONN-SECURE. UCONN-GUEST will not work

  • A Windows or Mac computer

 Instructions

Install DBeaver Community Edition

These instructions are for the Windows version. The MacOS installation is similar.

  1. Download the latest version of DBeaver Community from https://dbeaver.io/download/

  2. Run the installer by doubling clicking the file you downloaded

  3. Follow the installer prompts

image-20240125-155110.png
Click ‘Next’
image-20240125-155148.png
Review the license agreement and click ‘I agree’

  1. Run the DBeaver application.

  2. On first launch you may be promoted to modify Windows Firewall Settings

  1. You may be prompted to create a sample database. Click ‘No’

  2. Create the connection to the MariaDB server

If this is your first time connecting to a MariaDB database you may be prompted to download a driver.

  1. Finding your database

 

Troubleshooting

Connection Timed Out

If you receive a Connection Timed Out: Connect message make sure you are using the UCONN-SECURE Wi-Fi network or that you are connected to the Cisco AnyConnect VPN client and are connected

Access Denied Error

There are several possible causes for this error. Please check the following:

  1. The server host is correct and is set to opimdb.business.uconn.edu

  2. Your NetID is correct and entered for both Database and Username

  3. You typed your NetID password correctly. You can reset your NetID password on UConn’s NetID page here

Need Help?

For further assistance, contact the School of Business ITS helpdesk:

Email: help@business.uconn.edu

Locations and Phone numbers: Home | Information Technology Department (uconn.edu)

 

For more help, please contact our helpdesk at busn.help@uconn.edu