mysql - trouble with enabling relation view in phpmyadmin -
sorry post same question here (how enable relation view in phpmyadmin) it's marked unanswered , none of provided answers resolve issue.
my problem not have button 'relation view' in structure tab of database in phpmyadmin. on mac os x, mysql version 5.6.19. storage of relevant tables listed 'innodb' under operations, suggested in first answer of other question.
i have followed instructions here: http://www.w3expert.com/2008/03/how-to-enable-view-feature-in.html recommended in second answer of question above, restarted machine, still no 'relation view'.
the elaborate instructions have found these: http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage suggest there step after following instructions on w3expert.com:
"after having imported examples/create_tables.sql file, should specify table names in config.inc.php file. directives used can found in configuration."
i take mean after following w3expert.com's instructions, tables stored separately, , need point phpmyadmin toward them. idea how proceed?
i managed enable 'relation view' button following instructions here:
http://foundationphp.com/tutorials/pma_config.php
with few changes: left out " grant select on mysql.host 'pma'@'localhost'; " permissions settings set host differently: $cfg['servers'][$i]['host'] = '127.0.0.1'
Comments
Post a Comment