Mega Code Archive

 

Categories / MySQL Tutorial / Introduction

 

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