Summary MySQL 5.0 Certification Study Guide Book cover image

Summary Mysql 5.0 Certification Study Guide

- Paul DuBois, et al
ISBN-10 0672332701 ISBN-13 9780672332708
403 Flashcards & Notes
Scroll down to see the PDF preview!
  • This + 400k other summaries
  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo

A snapshot of the summary - MySQL 5.0 Certification Study Guide Author: Paul DuBois Stefan Hinz Carsten Pedersen ISBN: 9780672332708

  • 1 Client/Server Concepts

    This is a preview. There are 29 more flashcards available for chapter 1
    Show more cards here

  • Using what architecture does MySQL operate?
    Client/Server architecture
  • What are the three major components of a MySQL installation?
    1. MySQL Server
    2. Client Programs
    3. MySQL non-client utilities
  • Must mysql client long options have an equal (=) sign between the name and the value?
    Yes
  • What are the 5 options for a mysql client program to establish a connection?
    --protocol
    --host
    --port
    --shared-memory-base-name
    --socket
  • What are the 4 possible values for the --protocol parameter of mysql client programs? For local or remote? And for what OS?
    tcp - All - All OSes
    socket - Local - Unix only
    pipe - Local - Windows only
    memory - Local - Windows only
  • What is the requirement for using named pipe connections?
    Must be mysql-nt of mysql-max-nt server and with --enable-named-pipe options on the command line
  • What is the requirement for using shared memory connections? And what is the side affect?
    --shared-memory option on the command line

    Side effect: becomes default protocol
  • What 2 values for the --host option have special value?
    1. localhost > default protocol becomes unix socket
    2. . (dot) > default protocol becomes named pipe
  • What is the default mysql server port number?

    3306
  • What are the 2 purposes of the --socket option?
    1. To specify a unix socket file path
    2. To specify the name of the named pipe to use

To read further, please click:

Read the full summary
This summary +380.000 other summaries A unique study tool A rehearsal system for this summary Studycoaching with videos
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart