Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress Installing WordPress Locally Installing WordPress Locally Setting up the Environment

Rashaan Alexander
Rashaan Alexander
5,505 Points
Posted by Rashaan Alexander
Rashaan Alexander
5,505 Points

Error message - #3009 - Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50628...

Hi Everyone. I am getting the same exact error as this person 3 months ago.

Why would I have to update anything when I downloaded MAMp today?

How would I update MySQL if that is really the problem? Thanks.

I’m trying to set up my local environment on MAMP for the Wordpress local install tutorial. I'm following along with the video but running into an issue when adding the 'wpuser' to my 'wplocal' database. The two errors I'm receiving after entering my user details and clicking 'go' are:

  • 3009 - Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50638, now running 50723. Please use mysql_upgrade to fix this error.
  • The selected user was not found in the privilege table. There's nothing different about the steps I'm following to those in the video. My version of MAMP is a more recent one (5.1). Could this be the issue? Any help resolving would be great.