configuring phpmyadmin: why no table mysql.host for mysql56?
murrayeisenberg at gmail.com
Fri Feb 13 21:07:12 PST 2015
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 ?
Murray Eisenberg murrayeisenberg at gmail.com
503 King Farm Blvd #101 Home (240)-246-7240
Rockville, MD 20850-6667 Mobile (413)-427-5334
More information about the macports-users