linux下解决mysql table xxx doesn't exist
来源:互联网 发布:编程values是什么意思 编辑:程序博客网 时间:2024/05/16 01:24
报错:
org.apache.catalina.core.StandardContext loadOnStartupSEVERE: Servlet [spring-template] in web application [/cdh] threw load() exceptioncom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdh_self_insurance_dev.EC_PROMO' doesn't exist
原因:linux下mysql区分大小写,数据库中的表名与程序中的sql语句中的使用的表名大小写不一致导致的。
解决方法:
1、sudo find / -name my.cnf #查找my.cnf文件的路径2、找到 my.cnf文件改动my.cnf文件,在my.cnf中的[mysqld]下面(位置不能错)加上lower_case_table_name = 1这句(1表示不区分大小写,0区分大小写),保存重新启动mysql。
阅读全文
0 0
- linux下解决mysql table xxx doesn't exist
- Linux环境下MySQL报Table 'xxx' doesn't exist错误解决方法
- Linux下MySQL报Table 'xxx' doesn't exist错误解决方法
- 1146 - Table 'xxx.xxx' doesn't exist
- hibernate---Table 'XXX.XXX' doesn't exist
- MySql - 导入数据时 Table XXX doesn't exist 的解决
- Mysql table '' doesn`t exist
- Table 'database1.xxx' doesn't exist
- linux 启动mysql 时报:Table 'mysql.host' doesn't exist
- Mysql “Table 'mysql.servers' doesn't exist”
- windows下Mysql解决Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 10020---hibernate---Table 'XXX.XXX' doesn't exist
- 表不存在1146:table 'xxx.xxx' doesn't exist
- 数据库备份 Mysql table '' doesn`t exist
- mysql Table 'performance_schema.session_variables' doesn't exist
- mysql Table 'performance_schema.session_status' doesn't exist
- Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist mysql
- table 'mysql.proc' doesn't exist问题解决
- SQL server 数据库删除某行时 遇挫记
- 关于农行那点事
- 启动Eclipse-oxygen报错:发现了以元素 ‘d:skin’ 开头的无效内容
- js函数中关于this与event的用法
- 零基础掌握百度地图兴趣点获取POI爬虫(python语言爬取)(进阶篇)
- linux下解决mysql table xxx doesn't exist
- 智能指针
- 大数据挖掘教程(零基础)-hadoop
- I2C串口通信
- Linux 进程间通信方式(2)
- rac环境下resource 处于中间状态INTERMEDIATE的处理办法
- 跨域
- 腾讯绝地求生助手(战场助手)v1.0官方版下载
- DFS的递归实现