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