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

[Brandon Allbery]

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.

http://dev.mysql.com/doc/refman/5.6/en/grant-table-structure.html

-- 
brandon s allbery kf8nh                               sine nomine associates
allbery.b at gmail.com                                  ballbery at sinenomine.net
unix, openafs, kerberos, infrastructure, xmonad        http://sinenomine.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/macports-users/attachments/20150214/72b4e758/attachment.html>