In order to log into MySQL we must pass information to the MySQL client program when we start it.
This is done with the following commands and syntax.
c:\mysql\bin\mysql -u -p
The name of the program (mysql) is followed by the User flag (-u), the Password (-p) and finally the name of the database.
c:\mysql\bin\mysql -u yourUserName -p mypass databaseName
If we omit the password but still leave the password flag (-p), you will be prompted for it.
$ mysql -u yourUserName -p yourDatabaseName
Enter password:
You could also omit the name of the database as well.
$ mysql -u yourUserName -p
Enter password:
You could choose to select a specific database if your user has privileges on different databases.
mysql use yourDatabaseName
Database changed