INST 327 Lecture Notes - Lecture 3: Mysql
Document Summary
You can connect to your mysql server through the mysql client and by using the mysql command. At this moment, you do not need to give any password as by default it will be set as blank. It should be rewarded with a mysql> prompt. Now, you are connected to the mysql server and you can execute all the sql commands at the mysql> prompt as follows . Mysql ships with a blank password for the root mysql user. As soon as you have successfully installed the database and the client, you need to set a root password as given in the following code block . Now to make a connection to your mysql server, you would have to use the following command . Unix users will also want to put your mysql directory in your path, so you won"t have to keep typing out the full path everytime you want to use the command-line client.