loading local data is disabled; this must be enabled on both the client and server sides

简介: loading local data is disabled; this must be enabled on both the client and server sides

报错信息

loading local data is disabled; this must be enabled on both the client and server sides


报错原因

数据库权限不够,不能访问本地的数据

默认下面的local_infile是off,也就是关闭的


解决办法

通过下面的命令查看

show global variables like 'local_infile';

  • 如果显示 Value=OFF,则说明不可用。

通过set global local_infile=on;命令把这个改成on即可

目录
相关文章
|
6月前
|
Nacos 开发者
nacos报错 Server check fail, please check server 127.0.0.1 ,port 9848 is available , error ={}
在配置文件中指定的Nacos服务器地址未被项目使用,程序仍尝试连接到127.0.0.1。开发者寻求帮助排查问题,已花费多天未果。
|
2月前
|
监控
{"level":"warn","ts":"2023-11-07T00:35:53.400+0800","caller":"etcdserver/server.go:2048",&
{"level":"warn","ts":"2023-11-07T00:35:53.400+0800","caller":"etcdserver/server.go:2048",&
|
5月前
|
SQL 运维 关系型数据库
will be dropped if server is in r-o mode问题解决
【6月更文挑战第26天】will be dropped if server is in r-o mode问题解决
132 2
|
5月前
|
小程序
Failed to load local image resource Xx the server responded with a status of of 500 (HTTP/1.1 500)
Failed to load local image resource Xx the server responded with a status of of 500 (HTTP/1.1 500)
145 4
|
应用服务中间件
Tomcat报错:The required Server component failed to start so Tomcat is unable to start
Tomcat报错:The required Server component failed to start so Tomcat is unable to start
233 0
|
API
Deliver by interactive card server error
Deliver by interactive card server error
77 2
|
XML 应用服务中间件 数据格式
控制台报错: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting proper
控制台报错: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting proper
98 0
控制台报错: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting proper
|
XML 数据格式
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source‘ to ‘org.eclips
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source‘ to ‘org.eclips
111 0
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source‘ to ‘org.eclips
|
应用服务中间件 Android开发
Could not publish server configuration for Tomcat v6.0 Server at localhost. Multiple Contexts.
Could not publish server configuration for Tomcat v6.0 Server at localhost. Multiple Contexts.
139 0
Could not publish server configuration for Tomcat v6.0 Server at localhost. Multiple Contexts.
|
关系型数据库 MySQL 数据库连接
mysql报错:Data source rejected establishment of connection, message from server: \“Too many connectio
最近在做压力测试嘛,需要逐步增加用户量做验证,每个用户单独创建数据库进行连接,就要不断去创建数据库,这个报错也很容易理解,mysql连接数不够用了
317 0
mysql报错:Data source rejected establishment of connection, message from server: \“Too many connectio