[wp-hackers] Lost categories upgrading to 2.5.1

[Alexander Beutl]

>
> If WP never have privileges to CREATE table.. how where you able to
> install it first time?


Because it was created by another MySQL User who had permissions of course -
because it was imported with another user.

Yes this may create trouble - but as to the fact that UPGRADE and INSTALL
mean you change something at the system this *screams* for having the needed
privileges - and INSTALLING a plugin (which might need tables) or UPGRADING
the software (which might need this too obviously) means you will have
permission to do so - any lack of permission means it will fail!

Try installing some complex software (on linux since windows is something
totally different) which needs specific stuff at installation time which is
not available if you aren't logged in as root, will result in the same
failure if you do not have root permissions.

The thing is: Normally you have the privileges to do whatever your like at
> > your database
> >
> False. Normally you don't. Most DBs strictly limit the privileges
> available to users for security reasons.
>

I didn't speak about *good* configuration style but about the *normal*
conditions most hosters run the databases on. And you can not tell me most
hosters give you a database and more than one user while most users do not
have CREATE privilege. I am running websites at 6 different hosts and none
of them offers this for shared hosting by default. I asked a friend of mine
who has 70 different hosters in a hand full of different countries, with
many different shared hostings. His shared hostings never have more than one
user per database (if he doesn't explicitly ask for that) and this one has
all privileges on this DB. This are the normal conditions.

If you are not able to give WP the needed privileges at the time of upgrade
or install you simply can not upgrade and not install. Thats it and that is
why it is misconfiguration. It isn't when you are doing normal things like
blogging, commenting and stuff, but with every upgrade or install it is
misconfiguration if you lack the rights to change your DB structure since
WordPress havily depends on this DB and therefor will eventually have to
change it. This is exactly why you go to the upgrade page - to rearage the
DB - and of course one will need the rights to do it.


2008/4/30 Stefano Aglietti <steagl4ml at gmail.com>:

> On Wed, 30 Apr 2008 08:13:35 -0700, Elliotte Harold
> <elharo at metalab.unc.edu> wrote:
>
> >They never took them away. In fact, WordPress never had these privileges
> >in the first place. Like Wordpress itself, you're assuming things about
>
> If WP never have privileges to CREATE table.. how where you able to
> install it first time?
>
> --
>
> Stefano Aglietti - StallonIt on IRCnet - ICQ#: 2078431
> Email: steve at 40annibuttati.it steagl at people.it
> Sites: http://www.40annibuttati.it (personal blog)
>       http://www.wordpress-it.it (WordPress Italia)
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>