| 1. 1. 1. Connecting To Your Database |
|
|
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 <mysql_username> -p <password> <database name>
|
|
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 |