MySQL error # 1018 when creating a new user

Question

I want to create a new user for the MySql database, but when I create a new user with phpmyadmin, I get an error.

Executing an SQL query:

SHOW PLUGINS SONAME LIKE '%_PASSWORD_CHECK%'

I get an error message:

# 1018 - Unable to read the directory 'C: \ xampp \ mysql \ lib \ plugin \' (errno: 2 "There is no such file or directory")

Answer 1

This problem occurs because the folder does not exist. First you need to create a folder C:\xampp\mysql\lib\plugin\, and then try to create the user again.

Regards, C.