Installed by: David Matuszek,
System: Windows 2000 Pro
Installing MySQL on M134PC1, using the CD from "Murach's Java Servlets and JSP."
Quit all programs.
Opened MSJP(E:), opened MySQL folder, and ran
First two dialog windows, just clicked
C:\mysql as default installation directory, clicked
Chose "Typical" installation, clicked
\common\lib. (For me,
because I did a fairly sloppy installation.)
I didn't think mysql was running (I later discovered I was wrong), so I executed
C:\mysql\bin\winmysqladmin.exe and created an
file with a user and password. Clicked the line that suggested this was the
easiest thing to do for beginners.
mysql\bin and tried a simple run:
C:\mysql\bin>mysqlWelcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.46-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Then tried running it as in the book (page 315):
C:\mysql\bin>mysql -h localhost -u dave -pEnter password: *******
ERROR 1045: Access denied for user: 'dave@localhost' (Using password: YES)
I cannot run
winmysqladmin.exe again. A window comes up
briefly, then disappears. OK, I found it in the "tray" at the bottom of the
screen. (Several of them, in fact--so I closed all but one.)
(Murach, p. 608) Ran
Install.exe from the Murach CD, then
copied the contents of
E:\webapps (murach and MusicStore)
<tomcat>\webapps directory. Then,
C:\mysql\bin>mysql -u root -p < C:\downloads\Tomcat\jakarta-tomcat-5.5.9\webapps\murach\MurachMaster.sql
C:\mysql\bin>mysql -u root -p < C:\downloads\Tomcat\jakarta-tomcat-5.5.9\webapps \musicStore\MusicMaster.sql
Started Tomcat and tried
but couldn't get to it. Had to quit--try again later. (I think the problem is