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 Local WordPress Development Local WordPress Development Installing WordPress Locally

djey
djey
221 Points
Posted by djey
djey
221 Points

Getting this ERROR while creating user account then pressing go. Please Help.

Error SQL query: Edit Edit

SHOW PLUGINS SONAME LIKE '%_password_check%' MySQL said: Documentation

1018 - Can't read dir of 'C:\xampp\mysql\lib\plugin\' (errno: 2 "No such file or directory")

Add user account

Login Information

1 Answer

Kyle Schaper
Kyle Schaper
3,427 Points
Kyle Schaper
Kyle Schaper
3,427 Points

Okay so you are going to want to follow these steps, what worked for me was i went into xampp>mysql, created "lib" folder, went into "lib" folder and created "plugin" folder and tried creating a user again and now user creation works using phpmyadmin.

Rafael Vargas
Rafael Vargas
1,282 Points
Rafael Vargas
Rafael Vargas
1,282 Points

Thank you! It worked like a charm!

romanok
romanok
4,556 Points
romanok
romanok
4,556 Points

Thanks, quite an elegant solution :)

Evagelos Frigis
Evagelos Frigis
1,534 Points

Forgive me, but I'm still having difficulty understanding, so I'm going to be VERY precise with my question & steps.

Once I've started Apache & MySQL, I head over to http://localhost/phpmyadmin.

From there, your instructions say to create a folder called "lib" under mysql database, correct?

When I expand the mysql, there are a bunch of what I call folders, but when I hover the mouse over them, the are called "Structure". The first couple are titled "columns_priv", columns_states", "db", etc.

Above these folders I can select "New", but instead of creating what I would expect to be a folder, what pops up next to the databases and folders is "Table name", selection for a number of columns, then details for the table, such as "Name", Type", "Length/Value", "Default", etc.

If I just try to name the table "lib" and press Save, it says "missing value in this form!"

From here I don't want to save this table without any values unless that is what I need to do.

What should I do from here? Thank you!

romanok
romanok
4,556 Points
romanok
romanok
4,556 Points

Evagelos, you just need to create a regular empty folder in your file system, NOT a DB in PHPMyAdmin. Follow the instructions in Kyle's answer - in the end you need to have this folder created:

C:\xampp\mysql\lib\plugin

It can be different depending on where you have XAMPP installed. Let me know if you still have problems with it.

Bruno Brito
Bruno Brito
3,652 Points
Bruno Brito
Bruno Brito
3,652 Points

Thank you very much my good sir.