Re: PhpMyAdmin in EasyPHP cannot run DROP DATABASE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 2011-08-26, at 12:05 AM, Nam Gi VU <nam.gi.vu@xxxxxxxxx> wrote:

> Hi Bastien,
> I've create new user but cannot find where to log out to change logged-in user.
> This is strange...
> 
> On Thu, Aug 25, 2011 at 12:32 AM, Bastien Koert <phpster@xxxxxxxxx> wrote:
> On Wed, Aug 24, 2011 at 1:30 PM, Nam Gi VU <nam.gi.vu@xxxxxxxxx> wrote:
> > Thanks Bastien for your suggestion.
> > Though, I use the `root` account with `All privileges' but it still not
> > allowing me to call `drop database'.
> > What should I do next?
> >
> > On Wed, Aug 24, 2011 at 6:25 PM, Bastien <phpster@xxxxxxxxx> wrote:
> >>
> >> On 2011-08-23, at 6:44 AM, Nam Gi VU <nam.gi.vu@xxxxxxxxx> wrote:
> >>
> >> > Hi every one,
> >> > When trying to run my database script with `drop database` command, the
> >> > server refuse and said as below screenshot.
> >> > What should I do to enable this command?
> >> >
> >> > Regards,
> >> > Nam
> >> >
> >> >
> >> >
> >>
> >>
> >> Check that you phpmyadmin user account has the drop privilege. If not,
> >> grant that privilege or create another user account that does have more
> >> privileges
> >>
> >> Bastien
> >
> >
> > --
> > Nam
> >
> 
> try creating another user account, that isn't root (always a good
> habit) and giving that account the needed privileges and then
> configure PMA to use that account.
> 
> --
> 
> Bastien
> 
> Cat, the other other white meat
> 
> 
> 
> -- 
> Nam

You don't. Change the config.in.php file to use the new account

Bastien

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux