Solved

MySQL Missing tables

Posted on 2013-05-20
4
343 Views
Last Modified: 2013-05-29
I have workbench installed on server and can remote on to the server and I see all teh tables in my schema.

I have installed MySQL workbench on my desktop added the correct connection. My problem is alot of the tables are not been displayed in the desktop installation.

any ideas
0
Comment
Question by:Brogrim
  • 2
  • 2
4 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39181954
Hi.

Are you connecting with the same username? If yes, check if the GRANTS have been done for @localhost versus any connection.
SHOW GRANTS;

Open in new window


You can run that command on both your local desktop and the server. You should be able to spot the differences if they exist.
0
 

Author Comment

by:Brogrim
ID: 39183848
I have opened work bench on the server side, set my DB as the default schema and entered:

SHOW GRANTS;

This has returned one row:

'GRANT ALL PRIVILEGES ON *.* TO ''root''@''%'' IDENTIFIED BY PASSWORD ''********'' WITH GRANT OPTION'

I then opened the desktop workebench set my DB as the default schema and entered


SHOW GRANTS;

This has returned two rows:

'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER ON *.* TO \'root\'@\'%\' IDENTIFIED BY PASSWORD \'********\' WITH GRANT OPTION'

'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `%`.* TO \'root\'@\'%\' WITH GRANT OPTION'

obviously 2 diffrent results how fo I ensure that the tables can be included in the ODBC.
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39184456
Can you query the tables in question? i.e., do you have SELECT permissions but just cannot see the objects in the MySQL Workbench?

What version of MySQL are you using?

What version of the MySQL Workbench?
Did you customize any settings within MySQL Workbench or is this a clean installation?

Kevin
0
 

Author Comment

by:Brogrim
ID: 39204190
thanks
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now