CS142: Web Programming and Security

Install Ruby on Rails and MySQL on Windows

For Windows there is an all in one package called InstantRails which installs everything needed for this project including MySQL. Instructions as follows:

  1. If you do not have a Zip utility other than Windows' built-in compressed folders, download 7-zip. Windows' built-in compressed folders has problems dealing with InstantRails.
  2. Go to http://instantrails.rubyforge.org/ and follow the instructions (make sure you select version 2.0). If you've never downloaded InstantRails before, click on "Getting Started." If you have, see the "How to upgrade" instructions if you want to upgrade from your existing installation. Be sure to use 7-zip to unzip the files, not the normal Windows tools.

What's next?

  • There are plenty GUI applications for exploring MySQL. We recommend MySQL Adminstrator, and MySQL Query Browser for all platforms. There may be nicer interface s for Windows out there, but we will only be supporting MySQL Administrator and MySQL Query Browser.
  • You can also explore the database by invoking the following command:
    mysql -u root -D project6_development
    This will enter a MySQL command shell where you can type SQL statements (don't forget to terminate them with semicolons). Type exit when you are done.