MySQL Forums
Forum List  »  MySQL Query Browser

WB 5.2.25 on Open SUSE 11.2 -- Cannot see any objects from schema
Posted by: Alex Babev
Date: July 29, 2010 04:21PM

Hi,

I have this problem:

1. When I connect as root I can see all schemas and relevant objects there
2. I create schema world from script:( mysql web site )
I create user world to work with this schema an give it such privileges:

>>> GRANT ALL PRIVILEGES ON `world`.* TO 'world'@'localhost'

3. Then when I try to connect as user world I cannot see any schema/objects
I can issue queries and see results but I cannot see any schema objects which is not very good... (The Default combo box and Object window are both grayed )

-----------------------------------------------------
select * from world.City; --> this works

OR this 2 commands work also:
use world;
select * from City
------------------------------------------------------

This problem I have also in my old mysql-query-browser.


And one more question : What is the default password for OS User mysql if not secret ? May I change this password at all ? What will be the result ?
I thing that maybe I changed this to new value a month ago and maybe this is the problem for query-browsers...

Thanks in advance.

Alex.

Options: ReplyQuote


Subject
Written By
Posted
WB 5.2.25 on Open SUSE 11.2 -- Cannot see any objects from schema
July 29, 2010 04:21PM


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.