Re: PhpMyAdmin in EasyPHP cannot run DROP DATABASE
| From: | Nam Gi VU | Date: | Fri, 26 Aug 2011 04:21:05 +0000 |
| Subject: | Re: PhpMyAdmin in EasyPHP cannot run DROP DATABASE | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-314615@lists.php.net to get a copy of this message | ||
And in which section Bastien. Please be more specific.
On Fri, Aug 26, 2011 at 11:14 AM, Bastien <phpster@gmail.com> wrote:
>
>
> On 2011-08-26, at 12:05 AM, Nam Gi VU <nam.gi.vu@gmail.com> 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@gmail.com>
> phpster@gmail.com> wrote:
>
>> On Wed, Aug 24, 2011 at 1:30 PM, Nam Gi VU < <nam.gi.vu@gmail.com>
>> nam.gi.vu@gmail.com> 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@gmail.com>
>> phpster@gmail.com> wrote:
>> >>
>> >> On 2011-08-23, at 6:44 AM, Nam Gi VU < <nam.gi.vu@gmail.com>
>> nam.gi.vu@gmail.com> 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
>
--
Nam