I have the same problem and posted the same question here and there are those here who sincerely believe they have answered the question - but there has been a fundamental failure in communication.

The answers always come down to "change the Grant permissions".

From the point of view of the experienced person answering the question, that is correct. From the POV of the questioner, it's double talk. Let me explain the communication problem in a different way and maybe it will inspire someone to give me and Meghna a more useful answer.

You are stranger arriving at the airport of a large city You want to get to the Hilton Hotel. So you ask the baggage handler, "How do I get to the Hilton?"

He says, "Take a taxi right outside the front door of the passenger terminal. Have a nice day."

He walks away satisfied that he has answered the question. But you have a rental car awaiting you and wanted specific driving instructions.

So you go to the rental car counter and ask again, "How do I get to the Hilton Hotel?" and the agent says something like, "Drive out the front gate of the airport. Turn left onto Hwy #1. Go one mile and you will see a sign saying 'downtown via Main Street.' Get off there and drive 6 miles until you come to the corner of Main and Broad. Turn left onto Broad. Go four bocks. The Hilton is on the corner."

So when total newbies like me asks, how to I change permissions, we need the same kind of step by step instructions that do not make assumptions about what we already know or where we start from and are specific as to what action is to be taken at each point.

Last week, I went into MySQLadmin on my server using the Ensim Control Panel and tried to fix this problem. I thought I was granting the permission I needed so clients like MySQL Control could have access but all I succeeded in doing was breaking the web site run by the database. Fortunately the server's TS people were kind enough to repair the damage even though they do not provide MySQL support.

So I am now staying out of there until someone can give me reliable step by step instructions on how to"get to the Hilton." Or until someone drives me there. (I've also asked that if no one here has the patience to explain the steps, maybe someone would go to go into my server and make the needed changes that but no one responded).

So, what I am asking and what Meghna and others are asking is for someone to post those step by step instructions, perhaps using something like MySQL Admin, which many servers provide. That would educate us and make us self-reliant, which is what I was hoping for when I subscribed to this mailing list.

I would be very grateful to anyone who supports that goal.

Thank you,

At 11:09 AM 7/21/2003 -0400, you wrote: The problem is I am locked out of the database since I cant connect using any of the three user entries. So I cant add anything to the user table.

So I tried MySQL control centre and tried to access as root@127.0.0.1 and as root@localhost. Both of them don't work.

Please help...