AI 助理
备案控制台
开发者社区 数据库 文章 正文

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

2023-06-12 159
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 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即可

文章标签：
数据库
骚戴
目录
相关文章
游客j4mujezz7vm7y
|
13天前
|
监控
{"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",&
游客j4mujezz7vm7y
22 0
游客ehac6rtqb6f64
|
5月前
|
Nacos 开发者
nacos报错 Server check fail, please check server 127.0.0.1 ,port 9848 is available , error ={}
在配置文件中指定的Nacos服务器地址未被项目使用，程序仍尝试连接到127.0.0.1。开发者寻求帮助排查问题，已花费多天未果。
游客ehac6rtqb6f64
346 3
yuanzhengme
|
4月前
|
SQL 运维 关系型数据库
will be dropped if server is in r-o mode问题解决
【6月更文挑战第26天】will be dropped if server is in r-o mode问题解决
yuanzhengme
90 2
柠檬茶五元
|
4月前
|
小程序
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)
柠檬茶五元
107 4
唐城子
|
XML 应用服务中间件 数据格式
控制台报错： [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting proper
控制台报错： [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting proper
唐城子
92 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
唐城子
104 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.
唐城子
133 0
Could not publish server configuration for Tomcat v6.0 Server at localhost. Multiple Contexts.
中杯可乐多加冰
|
XML 应用服务中间件 Android开发
解决方案：Tomcat警告 [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source‘
解决方案：Tomcat警告 [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source‘
中杯可乐多加冰
156 0
解决方案：Tomcat警告 [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source‘
jieforest
|
MySQL 关系型数据库 Shell
Unit mysql.service failed to load: No such file or directory的解决办法
Failed to issue method call: Unit mysql.service failed to load: No such file or directory的解决办法 1、软件环境： OpenSUSE 13.
jieforest
3423 0
r35kc4qfp4orq
|
关系型数据库 MySQL Linux
ERROR!MySQL serverPID file could not be found! Starting MySQLERROR! The server quit without updating
mysql 启动报错总结
r35kc4qfp4orq
865 0