Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

WordPress Installing WordPress Locally Installing WordPress Locally Setting up the Environment

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.