Process Of Connecting To The Server

• MySQL client programs generally expect certain connection parameters when accessing a MySQL server.
  • The name of the host where the MySQL server is running.
  • An username.
  • A corresponding password.

• MySQL client programs use default values for any connection parameter option not specified.
  • The default hostname is localhost.
  • The default username on Linux is the user's login name.
  • No password is supplied if neither -p nor --password is given.

• The mysql client can be started as follows from a command-line prompt:

  mysql -h host_name -u user_name -ppassword

  • Alternative forms of the -h, -u, and -p options are:

    --host=host_name
    

    --user=user_name
    

    --password=password

    • There is no space between -p or --password= and the password following it.

How does MySQL process connection verification?

---

---

© 2007 John Michael Pierobon

Notes