Two Laptop Bag
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!