Connecting To Your Database : Introduction « Introduction « MySQL Tutorial






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








1.1.Introduction
1.1.1.Connecting To Your Database
1.1.2.To test whether a connection can even be made, execute the command STATUS.
1.1.3.Keywords may be entered in any lettercase.
1.1.4.You can use mysql as a simple calculator:
1.1.5.Database, table, index, column, and alias names are identifiers.