Solved

MySQL Missing tables

Posted on 2013-05-20
4
357 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Creating and Managing Databases with phpMyAdmin in cPanel.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

679 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