CODEWITHSUNDEEP
mysqlphpmyadminxampp
Jabbar Abdul
Jabbar Abdul

Reputation: 299

PhPmyadmin MySQL Error #1018 Xampp

I have Installed Xampp and configured MySQL and PhPmyadmin through it. BUt, when Itry creating a new User account It shows a MySQL error#1018 which says,

Error: 1018 SQLSTATE: HY000 (ER_CANT_READ_DIR)

Message: Can't read dir of '%s' (errno: %d - %s)

this Message takes me to SQL Query in the PHPmyadmin server which shows this,

SHOW PLUGINS SONAME LIKE '%_password_check%'

I am stuck with this. I have tried different things but In vain. I will appreciate help regarding this Issue. Thanks in advance.

Upvotes: 29

Views: 49214

Answers (2)

Tihauan
Tihauan

Reputation: 2780

If you installed XAMPP in the default folder C:\xampp go and manually create the folder C:\xampp\mysql\lib\plugin in Explorer. This should fix the user creation issue.

Upvotes: 94

Mohtisham Zubair
Mohtisham Zubair

Reputation: 723

This error is showing that you can not read in this directory. Please check this on mysql site

Normally it happens when you do not have rights on the folder, easiest is that you should give full control to "Everyone" group. Just right click on folder and in security tab "edit" and select "Everyone group" and in the lower window give check on Full control.

Upvotes: 2

Related Questions