错误1524(HY000):未加载插件'unix_socket'-Laragon [英] ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded - Laragon

问题描述

我正在将生产Wordpress网站迁移到我在Laragon上的本地环境.我做了以下事情:

I'm migrating my production wordpress website to my local environment on Laragon. I did the following:

打开Laragon的航站楼:
菜单> Laragon>终端
运行此命令:
scp user @ your-remote-host:/dump.sql C:/laragon/tmp/dump.sql

将sql-dump导入到我的本地数据库:
mysql -u root -p您的数据库<C:\ laragon \ tmp \ dump.sql

Opened Laragon's Terminal:
Menu > Laragon > Terminal
Ran this command:
scp user@your-remote-host:/dump.sql C:/laragon/tmp/dump.sql

Imported sql-dump to my local database:
mysql -u root -p your-database < C:\laragon\tmp\dump.sql

然后我将git repo克隆到 C:\ Laragon \ www \

Then I cloned my git repo to the root at C:\Laragon\www\

启动它，首先显示了实时服务器主页的副本，但是尝试转到另一个页面时出现错误.

Started it up and at first it displayed a replica of the live server's homepage, but gave an error when attempting to go to another page.

我停止了所有服务，并在重新启动时收到错误消息 ERROR 1524(HY000):未加载插件'unix_socket'

I stopped all services and when I restarted I was given the error ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

然后，当我尝试从终端执行 mysql -u root -p 时，我收到了相同的错误.

Then when I tried to do mysql -u root -p from the terminal I received the same error.

随着服务的启动，网页现在显示错误建立数据库"并显示 Error 1524

With the services started the web page now showed 'error establishing database' and displayed the Error 1524

这是 my.ini 文件的输出，该文件与 my.cnf

Here is the output of my.ini file which is the same as my.cnf

[client]
#password=your_password
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=256M
max_allowed_packet=512M
table_open_cache=256
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=4M
myisam_sort_buffer_size=64M
thread_cache_size=8
datadir= "C:/laragon/data/mysql"
plugin-load-add = auth_socket.so


secure-file-priv=""
explicit_defaults_for_timestamp=1
datadir= "C:/laragon/data/mysql"


[mysqldump]
quick
max_allowed_packet=512M

推荐答案

unix_socket ，又名 auth_socket 是非Windows身份验证插件.

unix_socket, aka auth_socket is non-windows authentication plugin.

我将从变量 skip-grant-表设置，然后使用以下方法更改根身份验证:

I'd start with the variable skip-grant-tables set, and change the root authentication using:

ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret")

然后删除"skip-grant-tables"选项并重新启动.

Then remove the 'skip-grant-tables' option and restart.

这篇关于错误1524(HY000):未加载插件'unix_socket'-Laragon的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！