Setting up and using database tools

From CTRNet Wiki
Jump to: navigation, search

Accessing your ATiM database through MySQL workbench using SSH

SSH is a network protocol that allows data to be exchanged using a secure channel between two devices over a network. This allows private data to be encrypted and transmitted over the internet securely.

You can find MySQL Workbench here: http://wb.mysql.com/

MySQL Workbench is a database design tool that integrates database design, modeling, creation and maintenance into a single, seamless environment for the MySQL database system.

To setup a SSH connection in MySQL Workbench, add a new connection.

New connec.png

A Manage DB Connections window will pop up.

  • 1) Type in a name for your connection in the Connection Name field.
  • 2) Set the Connection Method to Standard TCP/IP over SSH.
  • 3) Type in the server IP or domain name followed by “:22”.
  • 4) Type in the SSH user you have been given to connect with and password.
  • 5) MySQL Hostname will be your loopback address of 127.0.0.1
  • 6) The MySQL Server port is 3306
  • 7) Type in your MySQL username and password.
  • 8) Type in your default schema you wish to use.

MySQL SSH.png

Click Test Connection to verify that all connection parameters are valid. Once the connection is tested and is valid. Click OK to add the connection and connect to your MySQL databases.

Accessing your ATiM database through PHPMyAdmin

Open a web browser and type in your domain address in the address bar followed by, “/phpMyAdmin”. Example: https://yoursubdomainname.ctrnet-dev.ca/phpMyAdmin

Php myadmin.png

Type in your MySQL username and password and click Go to connect to your databases.

Retrieved from "http://www.ctrnet.ca/mediawiki/index.php/Setting_up_and_using_database_tools"
Personal tools