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

[Murray Eisenberg]

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 <murrayeisenberg at gmail.com> 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 <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

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