Would it be better instead to change things at https://trac.macports.org/wiki/howto/PHP so that the code for mysql_phpMyAdmin_pmaSetup.sql omits any reference to mysql.host but a note explains what to add in case you're using an older version of mysql?
> On 14 Feb2015, at 12:09 PM, Murray Eisenberg <[email protected]> > wrote: > > OK, I recall that now. Thanks. > > I added a note about this to https://trac.macports.org/wiki/howto/PHP. > >> On 14 Feb2015, at 12:17 AM, Brandon Allbery <[email protected]> wrote: >> >> On Sat, Feb 14, 2015 at 12:07 AM, Murray Eisenberg >> <[email protected]> wrote: >> 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 ? >> >> You are using obsolete instructions, it appears; the host table was >> deprecated in 5.6.3 and removed from the default schema in 5.6.7. >> >> http://dev.mysql.com/doc/refman/5.6/en/grant-table-structure.html >> >> > > --- > Murray Eisenberg [email protected] > 503 King Farm Blvd #101 Home (240)-246-7240 > Rockville, MD 20850-6667 Mobile (413)-427-5334 --- 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
