<== Back
Installing MySQL
1. Open a command prompt.
2. Type "cd \"
3. Type "dir" and you will see the zip directory you downloaded.
4. Now type in "jar -xvf mysql-(then just hit tab to complete the file name)" and hit "return"
5. Now you can do another dir and you will see the directory is extracted it to.
***At home you probably won't have the jar program. You should use winzip or whatever you have
at home to extract everything***
6. Now go inside the folder to see what you have: cd mysql-5[tab][enter]
7. You will see a "bin" folder
We are interested in (the DBMS)mysqld-max.exe and (the client)mysql.exe
These two are what we are going to use.
In this class we are going to write alot of scripts and stuff. Create a folder in the C:\ drive.
Whenever we come to class, we will put everything in that folder. (my folder is C:\cmcculloh\sql)
Putting it on the path
1. Go to control panel=>system=>advanced=>environment variables=>User variables for root=>new
2. Enter "MYSQL_HOME" for variable name and "c:\mysql-5.0.18-win32" for variable value.
3. Do the same for System variables.
4. Then find the "path" under System variables.
5. Click "edit"
6. Go to the beginning of the value and tpye "%MYSQL_HOME%\bin;" (do the same for user variables)
7. Now exit the current command window and start a new command prompt.
You should now have successfully downloaded and installed MySQL.
Test it
1. Go to your directory and type in mysqld-max
If it hangs here and does NOT come back with the prompt. You were successfull. Otherwise try
going to control panel=>administrative tools=>services and stoping the MySQL you find there.
Then type "mysqld-max remove" in the prompt. Then type "mysqld-max" again and it should hang
this time.
<== Back