Scribd
Upload
27 views

Installing Mysql On Windows Os: Connecting To

This document provides steps for installing MySQL on Windows and connecting to local and remote MySQL instances. It outlines installing prerequisites like Visual Studio, downloading MySQL Community, choosing a setup type during installation, configuring the server, and connecting using MySQL Shell, Workbench, and the command line. It also demonstrates creating new connections in Workbench to a local instance and a remote UNB instance, setting credentials, testing the connection, and executing queries.

Uploaded by

HMahdikhani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
27 views

Installing Mysql On Windows Os: Connecting To

This document provides steps for installing MySQL on Windows and connecting to local and remote MySQL instances. It outlines installing prerequisites like Visual Studio, downloading MySQL Community, choosing a setup type during installation, configuring the server, and connecting using MySQL Shell, Workbench, and the command line. It also demonstrates creating new connections in Workbench to a local instance and a remote UNB instance, setting credentials, testing the connection, and executing queries.

Uploaded by

HMahdikhani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 26

Installing MySQL on

Windows OS
Connecting to
 Local Instance
and
 UNBMySQL
Pre-requisite(s)
• Check installed programs on OS (Control Panel  Program & Features)
• Visual Studio C++ Redistributable 2015 – 2019
MySQL Community Downloads
• dev.mysql.com/download
Setup Type (Developer)
Setup Type (Server)
Setup Type (Client)
Setup Type (Full)
Setup Type (Custom)
Setup Type (Custom – contd.)
Setup Type (Custom – contd.)
Setup Type (Custom – contd.)
Setup Type (Custom – contd.)
Setup Type (Custom – contd.)
Standalone vs. InnoDB Cluster
Server Configuration (Protocol, port, …)

>> netstat –na –p TCP


Authentication Setup / Accounts & Roles
Windows Service Name

Service Control Manager


>> sc query type= service
>> sc queryex type= service state= all | find /i "My"
Apply Configuration
Connect to local instance via MySQL Shell(sqlsh) and MySQL Workbench
Connect to MySQL in UNB
• Create new connection
• Select connection type
• Set user names and passwords
• Test connection and save
• Connect to databases
• Execute simple query
Connect to MySQL in UNB - Create new connection

• Launch MySQL Workbench

Local Instance (MySQL on your computer)


Click on plus button (⊕) to add UNBMySQL
connection
Connect to MySQL in UNB – Select connection type

Select connection type

Select connection type


Connect to MySQL in UNB – Set username and passwords
fcslinux.cs.unb.ca
 Enter university credential

info1103.cs.unb.ca
 Enter MySQL credential
(provided by instructor)
Connect to MySQL in UNB – Test connection and save

Your local MySQL instance Saved UNBMySQL instance


Connect to MySQL in UNB – Connect to database

Connection to UNBMySQL Insatnce

List of databases

List of tables in selected


database Ch01_Text
Connect to UNBMySQL via cmd (Command-Line)

Connect to university
 ssh hmahdikh@fcslinux.cs.unb.ca
* enter university password
Connect to lab (ID415) and machine(10)
 ssh hmahdikh@id415m10.cs.unb.ca
* enter university password
Conect to MySQL
 mysql –h info1103.cs.unb.ca –u hmahdikh –p
* enter university MySQL password
Connect to database (Ch01_Text )
 use Ch01_Text;
See table inside the database
 show tables;
See data inside the table (AGENT)
 SELECT * FROM AGENT;

You might also like