What database privileges does a Wordpress blog really need?
What database privileges does a Wordpress Blog really need? 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 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 What's the best way to run Wordpress on the same do...
Read more…
Best practices for running Wordpress on the same domain as Rails app
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...
Read more…
