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

[Murray Eisenberg]

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.
> 
> http://dev.mysql.com/doc/refman/5.6/en/grant-table-structure.html
> 
> 

---
Murray Eisenberg		murrayeisenberg at gmail.com
503 King Farm Blvd #101		Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334