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 trialdjey
221 PointsGetting 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
3,427 PointsOkay 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
1,282 PointsThank you! It worked like a charm!
romanok
4,556 PointsThanks, quite an elegant solution :)
Evagelos Frigis
1,534 PointsForgive 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
4,556 PointsEvagelos, 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
3,652 PointsThank you very much my good sir.
iuliana sagaidak
4,797 Pointsthank you so much!!
Sardor Shaahmedov
334 PointsSardor Shaahmedov
334 Pointssame here