Brogrim
asked on
MySQL Missing tables
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
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
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
Are you connecting with the same username? If yes, check if the GRANTS have been done for @localhost versus any connection.
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.