What database privileges does a Wordpress Blog really need?

Database privileges a Wordpress blog has

I am setting up a few Wordpress blog sites. I have created a user in mysql that wordpress will use to access its database. The docs say to give this user all privileges on the database.

Does it really need full privileges? I expect not, so does anyone know the min set of privileges that it really needs?

3 Answers

I'm no Wordpress expert, but I would recommend it does actually have all privileges apart from GRANT. It will need to be able to create tables and insert/update etc. Several plugins use their own tables, which they create on the fly if they do not exist.

I grant:

ALTER
CREATE
CREATE
TEMPORARY
TABLES
DELETE
DROP
INDEX
INSERT
LOCK
TABLES
SELECT
UPDATE

What database privileges does Wordpress need?

Hope that helps anyone else that looks into this.

grant select, insert, delete, update, create, drop, alter on myblog

Best practices for running Wordpress on the same domain as Rails app

How to run Wordpress as a Rails application

What's the best way to run Wordpress on the same domain as a Rails application? I've got a standard Rails app with Nginx and Mongrel running at http _ mydomain. I need to run a Wordpress blog at http _ mydomain _ com _ blog. My preference would be to host the blog in Apache running on either the same server or a separate box but I don't want the user to see a different server in the URL. Is that possible and if not, what would you recommend to accomplish the goal? 5 Answers Actually, since you're using Nginx, you're already in great shape and don't need Apache. You can run PHP through fastcgi (there are examples of how to do this in the Nginx wiki), and use a URL-matching pattern in your Nginx configuration to direct some URLs to Rails and others to PHP. Here's an example Nginx configuration for running a WordPress blog through PHP fastcgi (note I've also put in the Nginx equivalent of the WordPress .htaccess, so you will also have fancy URLs alre…

The syntax is for the Wordpress style.css template element

I've recently embarked upon the grand voyage of Wordpress theming and I've been reading through the Wordpress documentation for how to write a theme. One thing I came across here was that the style.css file must contain a specific header in order to be used by the Wordpress engine. They give a brief example but I haven't been able to turn up any formal description of what must be in the style.css header portion. Does this exist on the Wordpress site? If it doesn't could we perhaps describe it here? I think all of the answers so far are valid (obviously, I linked to the docs myself). What I'm looking for is a more formal description, i.e. Case…