configuring phpmyadmin: why no table mysql.host for mysql56?
murrayeisenberg at gmail.com
Sat Feb 14 09:09:44 PST 2015
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 <allbery.b at gmail.com> wrote:
> On Sat, Feb 14, 2015 at 12:07 AM, Murray Eisenberg <murrayeisenberg at gmail.com> 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.
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