MySQL 8 Cookbook

How to do it...

Connecting to the MySQL client can be done with any of the following commands:

shell> mysql -h localhost -P 3306 -u <username> -p<password>

shell> mysql --host=localhost --port=3306 --user=root --password=<password>

shell> mysql --host localhost --port 3306 --user root --password=<password>

It is highly recommended not to give the password in the command line, instead you can leave the field blank; you will be prompted for a password:

shell> mysql --host=localhost --port=3306 --user=root --password  Enter Password:

1. The -P argument (in uppercase) is passed for specifying the port.
2. The -p argument (in lowercase) is passed for specifying the password.
3. There is no space after the -p argument.
4. For the password, there is ...