MySQL 8 Administrator???s Guide

Connecting to the MySQL server

In this section, we will explain how we can establish connection to the MySQL server. We will be using client programs for connecting to the MySQL server. For connecting to the server program, we need some information to specify the hostname, username, and the password of the MySQL account because we need to tell the client program which host the server is running in and the associated username and password. Although there will be default option values associated to these options, you can override the option value whenever it is necessary. For example, consider using the common client program mysql:

shell> mysql

In the preceding program, no option has been specified but the following defaults will be applied ...