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.
This happens when it requires you to enter a password and the user has either entered the wrong one or has not provided one at all. This can be easily configured using the following steps: Step 1: Open MySql. Step 2: Through phpMyAdmin/librarires, you should edit config.
Restart your xampp server. Go to localhost/phpmyadmin again. Try to login with root as username and leave the passwords filed blank. If this doesn't works then login with the password you have entered.
The #1045 error is a phpMyAdmin authentication error that can be caused by an incorrectly typed username or password. To troubleshoot this error, you should complete a password reset and make sure you're using the correct database host name.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With