1 / 32

MySQL

MySQL. Dr. Thomas E. Hicks Trinity University Computer Science. cmd Command Window. Launch & Configure. Launch Command Window Start Select Run  Enter cmd. CD  To Go To Root Directory CLS  To Clear Screen.

iden
Download Presentation

MySQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL Dr. Thomas E. Hicks Trinity University Computer Science

  2. cmdCommand Window Launch & Configure

  3. Launch Command WindowStart Select Run  Enter cmd

  4. CD\  To Go To Root DirectoryCLS  To Clear Screen

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

  6. Select Colors TabSelect Screen Background ColorSelect Screen Text Color

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

  8. Nicely Formatted Window Next Time You Start cmd

  9. ipconfig Find IP Address Of SystemInternet Protocol Subnet Mask Gateway

  10. ipconfigIP Address = 131.194.71.113

  11. Ipconfig /allShows DNS Servers, WINS Servers, etc.

  12. DNS Server Domain Name SystemDomain Name Server

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

  14. \\131.194.71.9 Uses IP Address

  15. ping Find IP Of DNS System Domain Name System

  16. ping ananke.cs.trinity.eduAttempts To Contact SystemSuccessful Uses DNSDomain Name Systemto Resolve IP Address

  17. ping net5.cs.trinity.eduAttempts To Contact SystemUnsuccessful Uses DNSDomain Name Systemto Resolve IP Address

  18. Starting MySQL On Servermysql –u??? -p???

  19. To See Services: Start Task ManagerRight Mouse Click On Tool Bar  Select Task Manager Select Services Tab FindMySQL

  20. To See Services:Right Mouse Click On My Computer  Select Manage Expand Services & Applications Select Services

  21. Launch MySQL on the Lab SystemMySQL Server

  22. -uroot • -u is to identify the user • root is the system administrator • System administrator is all powerful

  23. -ptrinity • -p is to identify the password • trinity is the root password on the lab systems

  24. Starting MySQL On A Remote Servermysql –u??? –h??? -p???

  25. -ustudent • -u is the student administrative user

  26. -pstudent • -p is to identify the password • student is the student password on the theAnankeMySQL Server

  27. -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

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

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

  30. MySQL ModevsDOS Mode

  31. 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.

  32. 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.

More Related