• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help getting started?

 
Bob Goodman
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I need help setting up mysql, and then setting up my Java EE application within eclipse to connect to the DB. I need to get moving on this. So can someone layout simple steps on how to set this all up. I downloaded MySQl and the workbench, as I downloaded it, towards the end, that last part of "configuring" failed. Again, help would be really appreciate it.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It sounds like you are asking someone to write a tutorial. Which instructions have you followed. Can you show a screenshot of what step you got up to and what failed.
 
Bob Goodman
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I dont know what to take the screen shot of tbh. Like I downloaded Mysql, and I downloaded a GUI to connect to the DB, the GUI wont connect and I think I had an issue when downloading MYsql. I uninstalled and reinstalled mysql a bunch of times, but same issue.

Once that is complete, I would like to set up my code within eclipse to use hibernate to connect to the DB.

I dont know if I explained it correctly, does that make sense?

thanks
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65342
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm a Mac guy, so I don't know how much of this is relevant to Windows, but I was able to set up MySQL in a matter of minutes.

  • I downloaded the installation package (a dmg for Mac, will be something else for Windows)
  • Ran the installers for the database server, the startup item, and the preference pane. (The latter is equivalent to the Windows control panel)
  • Adjusted the PATH variable in my bash rc to add the MySQL binaries folders. I have no idea what the Windows equivalent is, but seem to remember there's a GUI somewhere to manage environment variables.
  • At the shell, executed the following:
  • $ mysqladmin -u root password xxxxxx
    $ mysqladmin -u root -pxxxxxx -h localhost password xxxxxx
    $ mysqladmin -u root -pxxxxxx reload
    $ history -c


    (where xxxxxx is the password I chose)

  • At the shell entered the MySQL console:
  • $ mysql -u root -p
    and was able to enter commands such as show databases;

  • Then I followed the instructions for creating users and tables here:

  • http://dev.mysql.com/doc/refman/5.6/en/create-user.html
    http://dev.mysql.com/doc/refman/5.6/en/creating-tables.html

     
    Bob Goodman
    Ranch Hand
    Posts: 31
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    I dont have an issue downloading it, their is an MSI installer and its rly simple, I just have the issues I listed AFTER that.

    I just uninstalled it again, and will now go about reinstalling it again.

    I also have an issue with the "root password", it seems even though I install it over, I need the older root password. anyway to go about this? I saw some command line tut's on this, but I suck at cmd and when I tried it got nowhere.

    Anyone know how to fix these issues? I have literally been stuck on this for many weeks and I need to get it fixed so I can get to actual coding.

    thanks
     
    Bear Bibeault
    Author and ninkuma
    Marshal
    Pie
    Posts: 65342
    97
    IntelliJ IDE Java jQuery Mac Mac OS X
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    It sounds as if your initial Windows install has recorded settings in the registry (dramatic chord here indicating dread and hopelessness) or elsewhere that the subsequent installs are picking up.

    I'd google around to find out where MySQL stores stuff in Windows so you can clean out and do a true clean install.

    Helpful hint: "Sucking at the command line" is something you need to get over and get over quickly if you want to make it as a developer. Relying solely on GUI tools to develop is like trying to play concert piano while wearing welding gloves.
     
    Bill Gorder
    Bartender
    Posts: 1682
    7
    Android IntelliJ IDE Linux Mac OS X Spring
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Install mySQL
    http://www.serverintellect.com/support/mysql/mysql-install/

    Create a database on the server you just installed
    http://www.wikihow.com/Create-a-Database-in-MySQL

    create tables on that database and query it
    http://www.arachnoid.com/MySQL/index.html


    Once the database is created you can connect to it using other tools as well such as squirrel or dbvisualizer and run your create table scrips from there if you prefer a UI
    http://squirrel-sql.sourceforge.net/
    http://www.dbvis.com/

    I agree with Bear, getting familiar and comfortable with the command line is a critical skill for any developer.
     
    Bob Goodman
    Ranch Hand
    Posts: 31
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Thanks, but this is exactly why I had posting and want one on one help. If you read my posting you would see those links do not AT ALL help me.

    Thanks
     
    fred rosenberger
    lowercase baba
    Bartender
    Posts: 12266
    36
    Chrome Java Linux
    • Likes 2
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    People love to help around here, but you have to make it as easy as possible for them to do so. I would suggest you focus on one issue at at time. Try to give a clear explanation of what you've done. Saying " I downloaded a GUI to connect to the DB" doesn't really tell us anything. WHAT do you mean by "a GUI"?

    How do you know the GUI won't connect? What did you try? what did it say when you tried?

    the error messages that crop up actually mean something. Telling us what those are lets us help you.
     
    Bob Goodman
    Ranch Hand
    Posts: 31
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Hey Fred, sorry ,I see your point. When I get home later tonight I can get more into detail, please look back in the morning hopefully I can do it by then. Thanks all
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic