Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Tables could not be fetched

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
(I took this unanswered question from the internet beacuase it explained my situation very good and I am also using a mac)

I added a user A with only access to one Database 'B'.

If I log in with it in MySQL Workbench, it shows me:

Tables could not be fetched
Views could not be fetched
Stored procedures could not be fetched
Functionscould not be fetched
The fun thing is that under "Tables could not be fetched" all tables of the DB are shown. The query SHOW TABLES; also gives the correct result.

If I log in with the root user or a user with all privileges on . it displays everything correctly.

I have tried the solution mysql mysql_upgrade -u root -p --force and mysql_upgrade -u root -p but i got the errror below.


 
martin codey
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1005 (HY000) at line 547: Can't create table `mysql`.`db` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 549: Can't create table `mysql`.`global_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 600: Can't create table `mysql`.`roles_mapping` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 601: Can't create table `mysql`.`func` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 602: Can't create table `mysql`.`plugin` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 603: Can't create table `mysql`.`servers` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 604: Can't create table `mysql`.`tables_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 605: Can't create table `mysql`.`columns_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 606: Can't create table `mysql`.`help_topic` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 607: Can't create table `mysql`.`help_category` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 608: Can't create table `mysql`.`help_relation` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 609: Can't create table `mysql`.`help_keyword` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 610: Can't create table `mysql`.`time_zone_name` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 611: Can't create table `mysql`.`time_zone` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 612: Can't create table `mysql`.`time_zone_transition` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 613: Can't create table `mysql`.`time_zone_transition_type` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 614: Can't create table `mysql`.`time_zone_leap_second` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 615: Can't create table `mysql`.`proc` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 616: Can't create table `mysql`.`procs_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 620: Can't create table `mysql`.`general_log` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 624: Can't create table `mysql`.`slow_log` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 626: Can't create table `mysql`.`event` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 665: Can't create table `mysql`.`innodb_table_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 669: Can't create table `mysql`.`innodb_index_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 673: Can't create table `mysql`.`transaction_registry` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 727: Can't create table `mysql`.`proxies_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 733: Can't create table `mysql`.`table_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 734: Can't create table `mysql`.`column_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 735: Can't create table `mysql`.`index_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 745: Can't create table `mysql`.`gtid_slave_pos` (errno: 13 "Permission denied")
FATAL ERROR: Upgrade failed
 
Would you like to try a free sample? Today we are featuring tiny ads:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!