MySQL - Wordpress

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...

WordPress MediaWiki integration

WordPress MediaWiki integration On the other end of the spectrum, I would be happy if I could install a wiki and share the login credentials between WordPress and the wiki. I hacked MediaWiki a while ago to share logins with another site (in ASP Classic) via session cookies, and it was a pain to do and even worse to maintain. Ideally, I would like to find a plug-in or someone who knows a more elegant solution. 6 Answers The tutorial WordPress, bbPress & MediaWiki should get you on the right track to integrating MediaWiki into your WordPress install. It's certainly going to be a lot easier than hacking WordPress to have wiki features, especially with the sort of granular permissions you're describing. The link in this answer is broken. After a bit of googling I'm pretty sure that this is the page that the link was supposed to point Updated link Both MediaWiki and Wordpress support OpenID Though, I think for automatic logins (after you log in to one, you automa...

How to select posts with specific tags/categories in WordPress This is a very specific question regarding MySQL as implemented in WordPress . I'm trying to develop a plugin that will show (select) posts that have specific 'tags' and belong to specific 'categories' (both multiple) I was told it's impossible because of the way categories and tags are stored: wp_posts contains a list of posts, each post have an "ID" wp_terms contains a list of terms (both categories and tags). Each term has a TERM_ID wp_term_taxonomy has a list of terms with their TERM_IDs and has a Taxonomy definition for each one of those (either a Category or a Tag) wp_term_relationships has associations between terms and posts How can I join the tables to get all posts with tags "Nuclear" and "Deals" that also belong to the category "Category1"? 6 Answers I misunderstood you. I thought you wanted Nuclear or Deals. The below should giv...

How do I display database query statistics on Wordpress site? I've noticed that a few Wordpress blogs have query statistics present in their footer that simply state the number of queries and the total time required to process them for the particular page, reading something like: 23 queries. 0.448 seconds. I was wondering how this is accomplished. Is it through the use of a particular Wordpress plug-in or perhaps from using some particular php function in the page's code? 3 Answers Try adding this to the bottom of the footer in your template: <?php echo $wpdb->num_queries; ?> <?php _e('queries'); ?>. <?php timer_stop(1); ?> <?php _e('seconds'); ?> * or wp-admin/admin-footer.php if you want it to show in the backend admin panel. To explain pix0r's code: $wpdb->num_queries is the number of database queries. _e is for localization timer_stop() returns the amount of time taken to render the page ...

Showing posts with the label MySQL