PhPmyadmin MySQL Error #1018 Xampp

mysql phpmyadmin xampp
Jabbar Abdul picture Jabbar Abdul · Feb 3, 2017 · Viewed 48.4k times · Source

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.

Answer

Tihauan picture Tihauan · Feb 6, 2017

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.

Related questions

MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I installed xampp,but when I tried to run it I got an error as thus: Error MySQL said: Documentation 1045 - Access denied for user 'root'@'localhost' (using password: NO) Connection for controluser as defined in your configuration failed. phpMyAdmin …

Read More
PHP: maximum execution time when importing .SQL data file

I am trying to import a large .sql data file using phpMyAdmin in XAMPP. However this is taking a lot of time and I keep getting: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\…

Read More
phpmyadmin "no data received to import" error, how to fix?

I am using XAMPP on a pc atwork to host a database. I exported a backup ("bintra.sql") using phpmybackuppro. I use xampp on a mac at home, and when I try to import the sql file located on my …

Read More