Skip to main content

MyWeb Tutorials: Connect to DB remotely

In addition to accessing your database through phpMyAdmin on MyWeb, you may also connect to your database directly from your own computer using tools such as HeidiSQL, MySQL Workbench, DBeaver, or the MySQL command-line client. Remote database access allows you to manage tables, run queries, and test your applications more easily while developing locally. In this guide, you will learn how to enable remote access to your database on MyWeb (DirectAdmin) and how to configure your database client to connect securely to the server.

  • Login to https://myweb.cs.uwindsor.ca with your username and password
  • From "Account Manager" -> Databases. Select or create the database you want to connect to:


    image.png

  • Click on “Manage”


    image.png


  • Select the user you want to connect with, and click on “Manage”


    image.png


  • Scroll down to “Allowed Hosts” and add % in the “Allow access from” and click on “Add Host”


    image.png

    Note: % means any host


  • That’s it.

  • Now you can test connecting to the database from your computer (after connecting to VPN).

    Example:

    Host: myweb.cs.uwindsor.ca
Port: 3306
Database: testproj1_myDB
Username: testproj1_myDB
Password: <DB password>

You can use any client to connect and manage the database from your computer. I recommend HeidiSQL https://www.heidisql.com/download.php

image.png


Back to top