Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connecting to MYSQL

 
Candy Bortniker
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to connect to MYSQL to build a table. I know I did it last semester but I don't remember exactly what I did. It seems like there is a file I have to go into to change a setting but that could be wrong. Here is the exception I'm getting:

Unable to connect to any hosts due to exception:java.net.SocketException: Network is down:

Any suggestions?
 
Karen Gomes
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes there is my.ini or my.cnf that you can go and make changes to. This file is in your windows or winnt folder. The mysql/winmysqladmin.exe will also let you modify it. Also confirm if you are using the right userID and password.
I just spent the entire day today getting the initail set up for mysql working. Let me know if this still doesnt help.
Karen
 
Candy Bortniker
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It just occured to me that I the last time I worked with MYSQL I needed to click on something (a file maybe) and it would give me an icon down by the clock with the other icons. Once I get that icon I should be ok but I don't remember what to click on to get it. Does this sound familiar?
 
Lu Battist
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like you need to start mysql as a service.
Depending on your version, it does this automatically so you probaly have it there already, you'll just need to go to services and set it up as automatic or leave it in manual and actually start it.
 
Candy Bortniker
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, how would I do that exactly?
 
Malhar Barai
Author
Ranch Hand
Posts: 399
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi..
Alternatively you can put the winmysqladmin in the startup, this will make mysql start automatically when you system is started.
HTH
MB
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic