• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Setting up MySQL on Windows

 
Eric Kantola
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm trying to teach myself Java Servlets and JSP pages. I'm using Murach's Java Servlets and JSP, 2nd edition book.
I'm supposed to download MySQL from the website then install it, which I've done. The book recommends I install MySQL at C:\Program Files\MySQL\MySQL Server 5.0. It further recommends installing the book files, including the database files at C:\murach\servlet_jsp\db. I've done that.
When I double-click on the setup_db.bat file to run it, I get the following error message," The system cannot find the path specified. 'mysql' is not recognized as an internal or external command, operable program or batch file."
Please note that Tomcat and Netbeans are setup and configured adequately, so I don't think it has any interoperation problems.
Knowing that Windows gets a little picky about spaces in it's classpath, I changed "MySQL Server 5.1" to "MySQL_Server5.1". I still get the same error message.
What am I doing wrong?
Thank you in advance for your helpful replies.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64717
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
THis doesn't seem to have anything at all to do with Servlets and JSP, so I've modified the subject a bit and moved it to the JDBC forum.
 
dineshiop kumar
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
when you install mysql irrespective to the location you should add the jar file to the netbeans and connected it make sure the properties are correctly set
 
Paul Clapham
Sheriff
Pie
Posts: 20980
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm guessing that installing MySQL didn't change your PATH environment variable to include the bin folder of your MySQL install (or wherever mysql.exe ended up). If it didn't, then you're going to have to do that yourself.

(The PATH environment variable contains a list of Windows folders where Windows looks when you ask it to run some executable from the command line.)
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic