David Gerard wrote:
On 29 April 2010 23:06, Platonides Platonides@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.