bbPress

Info

• 6 posts
• 3 voices
• Started 4 years ago by clockworkjoe
• Latest reply from clockworkjoe
• This topic is resolved

Tags

• mysql admin

• Posts in this topic

Add admin powers to account in mysql?

1. • 
   • clockworkjoe
   • Member

   • Posted 4 years ago #

   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?
2. • 
   • Beer
   • Member

   • Posted 4 years ago #

   You can try this:

   UPDATE bb_usermeta SET meta_value = 'a:1:{s:9:"keymaster";b:1;}' WHERE meta_key = 'bb_capabilities' AND user_id = 1;
3. • 
   • clockworkjoe
   • Member

   • Posted 4 years ago #

   The wordpress database has a different prefix than BB, so there's no bb_capabilities.
4. • 
   • clockworkjoe
   • Member

   • Posted 4 years ago #

   Here's the current capabilities of the admin account

   a:1:{s:13:"administrator";b:1;}

   Can i just change this so it has both wordpress and bbpress admin powers?
5. • 
   • Sam Bauers
   • Key Master

   • Posted 4 years ago #

   If admin's user_id is not 1, then adjust that value. Also your table may be called "wp_usermeta":

   INSERT INTO bb_usermeta VALUES (meta_value = 'a:1:{s:9:"keymaster";b:1;}', meta_key = 'bb_capabilities', user_id = 1);
6. • 
   • clockworkjoe
   • Member

   • Posted 4 years ago #

   That worked! Thanks a bunch.

7. You must log in to post.