aspose file tools*
The moose likes JDBC and the fly likes MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL" Watch "MySQL" New topic
Author

MySQL

s daniel
Greenhorn

Joined: Nov 03, 2008
Posts: 9
hi, I'm new to java and MySql, I just downloaded MySql and trying to add a new scheme to the DB.

I logged in as localhost because I don't know what else to log in as. I haven't set up any admin username or password. I just unzipped the MySql into a folder.

I ran mysqld.exe --console
Then MySQLQueryBrowser.exe to create the scheme.
But I get "access denied for user "localhost" [MySQL error Number 1044] when I try to create a DB.

What am I doing wrong?
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39436
    
  28
Welcome to JavaRanch

You can't get MySQL to work at all unless you have a user name and password. Assuming you have got it installed, you need to do some setting up after installation, you have to set up user accounts with privileges if you need them.
Note there is a tutorial as chapter 3 of that manual, and there are different manuals for the different versions, eg 5.0, 5.1.
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3838

Mysql comes with default account for root
try
mysql -uroot


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39436
    
  28
You are getting desperate if you log on as root; better to set up a user name, if you can.
s daniel
Greenhorn

Joined: Nov 03, 2008
Posts: 9
Thanks for the help, I'll try it out
Ryan Denney
Greenhorn

Joined: Nov 12, 2008
Posts: 1
If you want a GUI for managing your DB, MySQL Front is a pretty good option. It costs $35, but if you're going to be doing a lot of DB work it's well worth the price.
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

Originally posted by Ryan Denney:
If you want a GUI for managing your DB, MySQL Front is a pretty good option. It costs $35, but if you're going to be doing a lot of DB work it's well worth the price.



I think it comes free of cost ..

Get it here.
You need to login , for downloading it ..


[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

MySQL Front is a different product than MySQL Workbench.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL