Re: [phpesp-general] Weird refusal to install

[Peter F. <pf...@uc...>]

Franky Van Liedekerke wrote:
> 
> 
> On Mon, Mar 16, 2009 at 12:51 PM, Peter Flynn <pf...@uc... 
> <mailto:pf...@uc...>> wrote:
> 
>     Franky Van Liedekerke wrote:
>      > On Wed, 07 Jan 2009 10:23:50 +0000
>      > Peter Flynn <pf...@uc... <mailto: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.

No need to remove it: if you just add the privs needed (actually I think 
only ADD is required) it should be fine as it stands.

///Peter