On 29 April 2010 23:06, Platonides
<Platonides(a)gmail.com> wrote:
It will probably still fail, but this time with
an error message.
It did indeed: MySQL insisting 'admin'@'localhost' didn't have the
right to create tables.
My GRANT line in the previous email was wrong - the one that works is:
grant all on techwiki.* to 'admin'@'localhost' identified by
'password';
I now have a bare 1.16b2 wiki :-)
- d.
That's a disturbing feature of mysql.
%@localhost has priority over admin@%
And mysql comes with a default %@localhost account. If you removed it,
the previous line would also work.