错误 1524 (HY000): 插件 'unix_socket' 未加载 - Laragon

2022-01-15 00:00:00 mariadb mysql 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 mpdump.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 mpdump.sql

然后我将我的 git 存储库克隆到 C:Laragonwww

Then I cloned my git repo to the root at C:Laragonwww

启动它，起初它显示了实时服务器主页的副本，但在尝试转到另一个页面时出错.

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): Plugin 'unix_socket' is not loaded

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.

相关文章