MySQL

Dr. Thomas E. HicksTrinity University Computer Science

cmdCommand Window

Launch & Configure

Launch Command WindowStart Select Run Enter cmd

CD\ To Go To Root DirectoryCLS To Clear Screen

Right-Mouse Click In Top Bar To Change Command Window Properties Select Properties

Select Colors TabSelect Screen Background ColorSelect Screen Text Color

Select Layout TabEnter Width & Height Push OK ButtonSave Properties For Future Windows Push OK

Nicely Formatted Window Next Time You Start cmd

ipconfigFind IP Address Of System

Internet ProtocolSubnet Mask

Gateway

ipconfigIP Address = 131.194.71.113

Ipconfig /allShows DNS Servers, WINS Servers, etc.

DNS ServerDomain Name SystemDomain Name Server

\\ananke.cs.trinity.edu Uses DNSDomain Name Systemto Resolve IP Address

\\131.194.71.9 Uses IP Address

pingFind IP Of DNS System

Domain Name System

ping ananke.cs.trinity.eduAttempts To Contact SystemSuccessful

Uses DNSDomain Name Systemto Resolve IP Address

ping net5.cs.trinity.eduAttempts To Contact SystemUnsuccessful

Uses DNSDomain Name Systemto Resolve IP Address

Starting MySQL On Server

mysql –u??? -p???

To See Services: Start Task ManagerRight Mouse Click On Tool Bar Select Task Manager

Select Services TabFind MySQL

To See Services:Right Mouse Click On My Computer Select Manage

Expand Services & ApplicationsSelect Services

Launch MySQL on the Lab SystemMySQL Server

-uroot-u is to identify the userroot is the system administrator

System administrator is all powerful

-ptrinity-p is to identify the passwordtrinity is the root password on the lab

systems

Starting MySQL On A Remote Server

mysql –u??? –h??? -p???

-ustudent-u is the student administrative user

-pstudent-p is to identify the passwordstudent is the student password on

the the Ananke MySQL Server

-hananke.cs.trinity.edu-h is to identify the host

ananke.cs.trinity.edu is the host MySQL Server

-h131.194.71.9 is the IP address associated with the Ananke host MySQL Server

Remote Login (from net3.cs.trinity.edu)mysql -ustudent –pstudent –hananke.cs.trinity.edu

Remote Login (from net3.cs.trinity.edu)mysql -ustudent –pstudent –h131.194.71.9

MySQL Modevs

DOS Mode

DOS Prompt – DOS ModeNot Connected To SQL Server!MySQL Commands, such as SELECT, CREATE, STATUS,

etc. will not work in DOS mode.DOS Commands, such as CLS, COPY, IPCONFIG, etc. will

work.

DOS Prompt – DOS ModeNot Connected To SQL Server!MySQL Commands, such as SELECT, CREATE, STATUS,

etc. will not work in DOS mode.DOS Commands, such as CLS, COPY, IPCONFIG, etc. will

work.