MySQL Forums
Forum List  »  MySQL Query Browser

Problem with my database in query browser
Posted by: Rick Broekaart
Date: February 13, 2012 11:21AM

Deare people,

I have a problem with Mysql query browser which i can't solve on my own.
The case is I wanted to create a view table, when i tried it didn't work. After that i typed a query in order to be able to create view tables. The query was:

CREATE USER root@....... IDENTIFIED BY ..........;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE VIEW ON products.* TO root@........

The result was that i couldn't produce any query's anymore. So, i closed query browser. But then i couldn't acces query browser any more with my old password. Only with the new 'password' which i filled in after IDENTIFIED BY. But when i am in query browser now by filling in the new password i don't have any acces to my databases, only to 1 information_schema database.

So my question is: How can i get back to my databases? Does anyone know what i did by filling in that query and how to solve my problem? I hope so!

Kind regards,


Rick

Options: ReplyQuote


Subject
Written By
Posted
Problem with my database in query browser
February 13, 2012 11:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.