Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 507
Jabbar Abdul Avatar asked Feb 03 '17 22:02

Jabbar Abdul


People also ask

Why is phpMyAdmin showing Access Denied?

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.

Why is phpMyAdmin not connecting?

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.

How do I fix error 1045?

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.


2 Answers

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.

like image 113
Tihauan Avatar answered Sep 21 '22 23:09

Tihauan


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.

like image 30
Mohtisham Zubair Avatar answered Sep 25 '22 23:09

Mohtisham Zubair