configuring phpmyadmin: why no table mysql.host for mysql56?

[Murray Eisenberg]

I have a newly installed working installation of mysql56-server and mysql56 from MacPorts. I already had a working apache2 and php56 with apache2 support.

Next I installed phpmyadmin @4.3.9_0+php56 and have a suitable config.inc.php so that under apache2 I can run phpmyadmin in Safari.

I'm now trying to install pmadb (Step 6 at https://trac.macports.org/wiki/howto/PHP) and already ran:

  mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql

When running the script mysql_phpMyAdmin_pmaSetup.sql with contents as indicated at https://trac.macports.org/wiki/howto/PHP, I'm at the step:

  GRANT SELECT ON mysql.host TO 'pma'@'localhost';

This gives:  ERROR 1146 (42S02): Table 'mysql.host' doesn't exist

And indeed, that table does not exist. (I see this by executing mysql commands "use mysql;" and then "show tables;" ; I see the same thing by looking at database mysql in phpmyadmin)

Why not? Should it not have been created when I originally installed mysql56-server and executed mysql_install_db ?

How fix?
---
Murray Eisenberg		murrayeisenberg at gmail.com
503 King Farm Blvd #101		Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334