File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes General Computing and the fly likes Mysql administration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Mysql administration" Watch "Mysql administration" New topic

Mysql administration

Shridhar Raghavan
Ranch Hand

Joined: May 27, 2010
Posts: 71
I know this is not the post but hoping to get an answer since the guys at mysql forums are too busy

I have a windows box and installed mysql through the no install zip archive.

Problem is the root user has no grant priveleges or priveleges to create a new user or a database. Now how do i create a database? Is there something wrong with the zip archive? I have tried 5.6 and 5.1.

Also tried GRANT ALL ON *.* to <root-user> with GRANT OPTION;
I get access denied.

Have read the mysql guide for causes of the errors, nothing seems to work.
I agree. Here's the link:
subject: Mysql administration
It's not a secret anymore!