Solved

MySQL Missing tables

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
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…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

943 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

6 Experts available now in Live!

Get 1:1 Help Now