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                [email protected]
503 King Farm Blvd #101         Home (240)-246-7240
Rockville, MD 20850-6667        Mobile (413)-427-5334





_______________________________________________
macports-users mailing list
[email protected]
https://lists.macosforge.org/mailman/listinfo/macports-users

Reply via email to