Installing MySQL is a lot more straightforward than installing ColdFusion. So I won't walk you through that entire process, but you will find URLs in that same file, in your Project folder, that you can use to download the SQL Administrator and a number of other handy tools that go along with it.
Again, make sure when you install MySQL that you keep track of the password that you have to enter along the way because you will also need that.
Once you have MySQL installed, you can launch it from the Start Menu on the PC or by going to your Applications folder on the Mac. Let's start by opening the MySQL Administrator. Here is a tip. When you first launch MySQL and you are asked for a Username and Password, you may be scratching your head saying, I never entered a Username, I just entered a Password. What's the Username? Well, here is the tip, by default when you use MySQL, the Username is root, and if it's not already inserted into the Username field, like it is here, you can simply type root into the Username field and then enter whatever Password you created as you installed it.
Once it's installed, you can create a specific user for the Jump Start database or you can simply use the root user. To create new users, you will use the User Administrator feature. The MySQL database server can house multiple databases and it can have multiple users, each with varying degrees of access to those databases. If you are working with multiple databases, it's a good idea to setup multiple users, that way you can have multiple web applications using different databases without worrying about them interfering with each other.
If you are only using MySQL for this training and you haven't set anything else up, you don't need to go through the extra step of setting up a user, but if you do want to add a user, this is the dialog where you will do so.
By the way, if you are on a Macintosh, these links are across the top of this dialog, not down the left side like this.
After you have filled out all of the fields to setup a new user, you will want to setup the Schema Privileges specific for your database. Again, you don't have to do this for this series, but if you are working with multiple databases, it's definitely good practice. What you do have to for this series is to restore the database file that I have included in your sample files.
Transcription by:
Scribe4you Transcription Services