Problem with my database in query browser
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
Subject
Written By
Posted
Problem with my database in query browser
February 13, 2012 11:21AM
February 24, 2012 09:32AM
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.