Solved

MySQL Missing tables

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 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