Summary: Mysql 5.0 Certification Study Guide | 9780672332708 | Paul DuBois, et al

Summary: Mysql 5.0 Certification Study Guide | 9780672332708 | Paul DuBois, et al Book cover image
  • 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
Discover Study Smart
Remember faster, study better. Scientifically proven.
Trustpilot Logo

Read the summary and the most important questions on MySQL 5.0 Certification Study Guide | 9780672332708 | Paul DuBois; Stefan Hinz; Carsten Pedersen

  • 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