Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySQL Missing tables

Posted on 2013-05-20
4
Medium Priority
?
361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 60

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 60

Accepted Solution

by:
Kevin Cross earned 2000 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 your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

722 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