http://bbpress.org/forums/ bbPress Support Forums Topic: Add admin powers to account in mysql? en Fri, 09 Jan 2009 23:08:34 +0000 http://bbpress.org/forums/topic/add-admin-powers-to-account-in-mysql#post-15735 Thu, 24 Apr 2008 06:17:45 +0000 clockworkjoe 15735@http://bbpress.org/forums/ <p>That worked! Thanks a bunch. </p> http://bbpress.org/forums/topic/add-admin-powers-to-account-in-mysql#post-15733 Thu, 24 Apr 2008 00:19:02 +0000 sambauers 15733@http://bbpress.org/forums/ <p>If admin's user_id is not 1, then adjust that value. Also your table may be called "wp_usermeta":</p> <pre><code>INSERT INTO bb_usermeta VALUES (meta_value = &#39;a:1:{s:9:&quot;keymaster&quot;;b:1;}&#39;, meta_key = &#39;bb_capabilities&#39;, user_id = 1);</code></pre> http://bbpress.org/forums/topic/add-admin-powers-to-account-in-mysql#post-15729 Wed, 23 Apr 2008 22:11:26 +0000 clockworkjoe 15729@http://bbpress.org/forums/ <p>Here's the current capabilities of the admin account</p> <p>a:1:{s:13:"administrator";b:1;}</p> <p>Can i just change this so it has both wordpress and bbpress admin powers? </p> http://bbpress.org/forums/topic/add-admin-powers-to-account-in-mysql#post-15728 Wed, 23 Apr 2008 22:05:36 +0000 clockworkjoe 15728@http://bbpress.org/forums/ <p>The wordpress database has a different prefix than BB, so there's no bb_capabilities. </p> http://bbpress.org/forums/topic/add-admin-powers-to-account-in-mysql#post-15717 Wed, 23 Apr 2008 14:33:24 +0000 Beer 15717@http://bbpress.org/forums/ <p>You can try this:</p> <p>UPDATE bb_usermeta SET meta_value = 'a:1:{s:9:"keymaster";b:1;}' WHERE meta_key = 'bb_capabilities' AND user_id = 1; </p> http://bbpress.org/forums/topic/add-admin-powers-to-account-in-mysql#post-15707 Wed, 23 Apr 2008 05:49:52 +0000 clockworkjoe 15707@http://bbpress.org/forums/ <p>I messed up when I installed BBpress on my wordpress site initially so that wordpress database integration didn't work. I've fixed it though with one mistake. My wordpress admin account does not have admin powers for BBpress and the current BBpress admin account won't work since BBpress now only looks at the wordpress database. I can access the mysql database directly through cpanel and phpmyadmin. How do I edit my account entry so it has bbpress admin powers? </p>