OPIM MariaDB Connection Setup

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

If not on campus, you must first connect to the Cisco AnyConnect VPN before connecting to the database. While not recommended, you can use the UConn AnyWare School of Business Desktop if you are unable to install the Cisco AnyConnect VPN software

A Windows or Mac computer

Instructions

Install DBeaver Community Edition

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

Download the latest version of DBeaver Community from https://dbeaver.io/download/
Run the installer by doubling clicking the file you downloaded
Follow the installer prompts

Click ‘Next’

Review the license agreement and click ‘I agree’

Run the DBeaver application.
On first launch you may be promoted to modify Windows Firewall Settings

You may be prompted to create a sample database. Click ‘No’
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.

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:

The server host is correct and is set to opimdb.business.uconn.edu
Your NetID is correct and entered for both Database and Username
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)

BUSN IT