configuring phpmyadmin: why no table mysql.host for mysql56?
murrayeisenberg at gmail.com
Sat Feb 14 09:20:42 PST 2015
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.
> 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
More information about the macports-users