错误 1524 (HY000): 插件 'unix_socket' 未加载 - Laragon-数据库问题

ERROR 1524 (HY000): Plugin #39;unix_socket#39; is not loaded - Laragon(错误 1524 (HY000): 插件 unix_socket 未加载 - Laragon)

本文介绍了错误 1524 (HY000): 插件 'unix_socket' 未加载 - 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.

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