Re: [phpesp-general] Weird refusal to install

[Franky V. L. <lie...@te...>]

On Mon, Mar 16, 2009 at 12:51 PM, Peter Flynn <pf...@uc...> wrote:

> Franky Van Liedekerke wrote:
> > On Wed, 07 Jan 2009 10:23:50 +0000
> > Peter Flynn <pf...@uc...> wrote:
> >
>
>
> I finally found it. The mysql_create.sql is broken as shipped, as it
> does not allow the phpesp user to create, drop, or alter, so it can
> never install the data. I used the following:
>
> UPDATE db set create_priv='Y',drop_priv='Y',alter_priv='Y'
>  where user='phpesp';
>
> UPDATE user set select_priv='Y',insert_priv='Y',update_priv='Y',
>  delete_priv='Y',create_priv='Y',drop_priv='Y',alter_priv='Y'
>  where user='phpesp';
>
> flush privileges;
>
>
heh ... I never used that script myself on mysql 5 :-)
I'm going to remove that script and change the INSTALL instructions to just
create a mysql user yourself ... much safer and more in line with other
programs.

Franky