Need help getting started?

[Bob Goodman]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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