ubuntu下mysql有表却提示table doesn't exist

最新推荐文章于 2024-12-24 11:47:09 发布
最新推荐文章于 2024-12-24 11:47:09 发布
阅读量1k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： web 文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_42451919/article/details/82631917
本文介绍了如何在Linux环境下配置MySQL使其不区分大小写。通过编辑配置文件mysqld.cnf并添加lower_case_table_names=1参数实现。适用于希望统一表名大小写的开发者。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

linux里面的mysql是区分大小写的，windows下的mysql不区分。在mysql的安装目录里面找到mysqld.cnf文件，在[mysqld]的下面（可以看到还有别的配置信息）添加   lower_case_table_names=1   就行了。

我的这个配置文件的目录是/etc/mysql/mysql.conf.d文件夹下。

【chat】4: ubuntu20.04：数据库创建：mysql8 导入5.7表
突围
11-11 620
chat
docker mysql:8.0.29
weixin_58228046的博客
05-10 630
一、环境准备 ubuntu 20.04.4 docker 20.10.15 二、pull mysql:8.0.29 lxx@ubuntu:~$ docker images REPOSITORY TAG IMAGE ID CREATED SIZE redis 7.0.0 1175989749b4 6 hours ago 412MB mysql 8.0.29 96d...
mysql数据库中明明有表，但是却提示表不存在
hdn_kb的博客
12-14 2万+
在linux中安装了mysql之后，发生了一个问题：明明表在数据库中存在，但是通过select语句查询却提示Table 'tablename' doesn't exist 经过排查是因为使用select语句进行查询的时候没有对表名区分大小写，这就需要在/etc/my.cnf配置文件中添加：lower_case_table_names=1，然后将mysql服务重新启动即可。 ...
mysql表不存在_MySQL>表不存在。但这确实（或者应该如此）
weixin_32233909的博客
01-18 841
我确实更改了MySQL安装的datadir，并按照某些步骤运行良好。我曾经动过的每个基地都正确地移动了，但是一个。我可以连接和使用数据库，即使SHOW TABLES也会正确返回所有表，并且每个表的文件都存在于mysql数据目录中。但是，当我尝试在此处选择内容时，它说该表不存在。但是表确实存在，它甚至显示在SHOW TABLES语句中！我的猜测是，SHOW TABLES会以某种方式列出文件的存在，文...
mysql 打印错误信息表,获取表不存在错误，但表确实存在（ActiveRecord :: StatementInvalid Mysql2 :: Error：表不存在）...
weixin_42309311的博客
02-18 393
I am getting the following error when I try to access one of my pagesActiveRecord::StatementInvalid (Mysql2::Error: Table 'p478r679_partybot.secretsanta' doesn't exist: SHOW FIELDS FROM 'secretsanta')...
【Ubuntu学习MySQL——MySQL基本操作命令】
qq_43561603的博客
07-05 2144
单列索引，即一个索引只包含单个列，一个表可以有多个单列索引，但这不是组合索引。组合索引，即一个索引包含多个列。（3）重置序列：如果你删除了数据表中的多条记录，并希望对剩下数据的AUTO_INCREMENT列进行重新排列，那么你可以通过删除自增的列，然后重新添加来实现。比如说，在人员管理系统中，你删除一个人员，你既需要删除人员的基本资料，也要删除和该人员相关的信息，如信箱，文章等等，这样，这些数据库操作语句就构成一个事务！（2）唯一索引：它与前面的普通索引类似，不同的就是：索引列的值必须唯一，但允许有空值。
table 'mysql.proc' doesn't exist问题解决
m0_38121234的博客
08-25 1337
不小心把mysq的内置库mysql干掉了，网上查了资料大部分基于windows的，先整理linux的解决方案： 1、mysql_install_db 重新初始化 2、进入/var/lib/mysql/mysql 修改权限 chown mysql.mysql * ...
idea中的显示错误：Table 'mysql.emp' doesn't exist
06-25
我们正在解决用户的问题：在IDEA中运行项目时出现"Table'mysql.emp'doesn'texist"错误。根据引用内容，我们可以总结出几种可能的原因和解决方案：可能原因：1.SQL语句错误：可能是SQL语句中表名写错或者数据库名写错...
navicat 1146 ‘mysql,user’ dont exist
03-09
错误`ERROR 1146 (42S02): Table 'mysql.user' doesn't exist`表明MySQL系统数据库（`mysql`库）中的核心表`user`丢失。常见原因包括： 1. **MySQL升级失败**：升级过程中意外中断导致系统表损坏或缺失[^1]； 2. **...
2025-07-15T01:47:13.079564Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-07-15T01:47:13.085230Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-07-15T01:47:13.085268Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-07-15T01:47:13.089551Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2025-07-15T01:47:13.091858Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:47:13.092032Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2025-07-15T01:47:13.092048Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2025-07-15T01:47:13.092168Z 0 [ERROR] [MY-000068] [Server] unknown option '--skip-host-cache'. 2025-07-15T01:47:13.092876Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-07-15T01:47:14.634541Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.3) MySQL Community Server - GPL. 2025-07-15T01:47:14.634553Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2025-07-15 01:48:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.3-1.el9 started. 2025-07-15 01:48:15+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-07-15 01:48:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.3-1.el9 started. '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2025-07-15T01:48:15.303942Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2025-07-15T01:48:15.484047Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.3) starting as process 1 2025-07-15T01:48:15.489065Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-07-15T01:48:15.826051Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysqld: Table 'mysql.plugin' doesn't exist 2025-07-15T01:48:15.987952Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2025-07-15T01:48:15.988248Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:15.988425Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:15.988643Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:15.988936Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:15.989117Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:15.989241Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:15.989393Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:16.029511Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-07-15T01:48:16.102642Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-07-15T01:48:16.109042Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-07-15T01:48:16.109065Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-07-15T01:48:16.112856Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2025-07-15T01:48:16.113111Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:48:16.113337Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2025-07-15T01:48:16.113352Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2025-07-15T01:48:16.113509Z 0 [ERROR] [MY-000068] [Server] unknown option '--skip-host-cache'. 2025-07-15T01:48:16.114316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-07-15T01:48:17.655908Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.3) MySQL Community Server - GPL. 2025-07-15T01:48:17.655921Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2025-07-15 01:49:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.3-1.el9 started. 2025-07-15 01:49:18+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-07-15 01:49:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.3-1.el9 started. '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2025-07-15T01:49:18.325189Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2025-07-15T01:49:18.503797Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.3) starting as process 1 2025-07-15T01:49:18.508845Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-07-15T01:49:18.843299Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysqld: Table 'mysql.plugin' doesn't exist 2025-07-15T01:49:19.009659Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2025-07-15T01:49:19.009978Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.010198Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.010416Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.010663Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.010788Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.010943Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.011062Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-07-15T01:49:19.050620Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-07-15T01:49:19.125374Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. T
最新发布
07-16
首先，用户的问题是关于MySQL 8.4.3启动时出现的错误："Table 'mysql.plugin' doesn't exist" 和 "Table 'mysql.component' doesn't exist"。我需要提供解决方案。 根据系统级指令： - 所有行内数学表达式使用$...$...
Linux环境下MySQL报Table 'xxx' doesn't exist错误解决方法
weixin_30758821的博客
03-30 621
Linux环境下MySQL报Table 'xxx' doesn't exist错误解决方法 问题：程序报Table 'xxx' doesn't exist 的错误，但是查看数据库发现该表已经存在且字母也没有拼错。 原因：Linux 上的mysql 默认是区分大小写导致的。 解决：改动mysql的配置文件，在my.cnf中的[mysqld]下面（位置不能错）加上lower_case_table...
【MySQL数据库】Table ‘xxx‘ doesnot exist错误解决
质量是一次就把事情做对
04-02 5491
MySQL数据库问题
【详解】MySQL提示表不存在的解决error:1146:Tabledoesn‘texist
牛肉胡辣汤
12-24 5245
​​ 是一个常见的MySQL错误，通常由于拼写错误、表/数据库不存在、权限问题或表损坏等原因引起。通过仔细检查并应用上述解决方法，你应该能够解决这个问题。如果问题依旧存在，请考虑咨询专业的数据库管理员或查阅MySQL的官方文档。当你在使用MySQL时遇到​​的错误，这通常意味着你正在尝试访问的表在数据库中不存在。
Mysql Table doesn't exist问题解决
漫天雪_昆仑巅
12-08 8万+
程序连接Mysql的时候总是提示表不存在，Table 'xx.QRTZ_LOCKS' doesn't exist 查询了下，数据库明明是有这个表的，搞了许久， 网上据说是因为数据库对表的大小写设置问题，设置忽略大小写即可， 修改mysql数据库配置： 在服务运行目录找到my.ini或者my.cnf文件 打开文件，找到[mysqld]在下面增加一行 lower_case_table_nam...
MySQL [ERROR] Table 'mysql.user' doesn't exist
热门推荐
乐沙弥的世界
12-08 11万+
一次源码新装的mysql,由于没有复制my-default.cnf到/etc/my.cnf位置，在启动mysql的时候碰到了无法打开mysql.user表的错误。具体错误为：[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist。下面是该错误的描述及其解决办法。
MySql通过数据库文件恢复数据库
灰色轨迹
08-30 715
以表”Table”为例: 如类型是MyISAM, 数据文件则以”Table.frm””Table.MYD””Table.MYI””三个文件存储于”/data/$databasename/”目录中. 如类型是InnoDB, 数据文件则存储在”$innodb_data_home_dir/″中的ibdata1文件中(一般情况)，结构文件存在于table_name.frm中. MySQL的数据库文...
使用navicat连接数据库时显示1146-table 'mysql.proc' doesn't exist，这个怎么解决
孤竹的博客
12-04 3万+
0 数据库的系统表丢失了。 1 考虑以下几种处理方式： a. 从其它相同版本的mysql数据库导出个proc的数据通过命令行导入进去； b. 或者拷贝下data/mysql/proc.frm, proc.MYD, proc.MYI 三个文件到你的数据库data/mysql/ 目录下，重启数据库； c. 如果之前有数据库备份，提取出其中的mysql.proc表来导入（备份很重要啊）； 2 问题：
mysql 打开某个表提示 doesn't exist
06-01
如果在使用 MySQL 数据库时打开一个表时提示 "doesn't exist"，可能是由于以下原因之一： 1. 表名拼写错误：请检查您输入的表名是否正确。请注意大小写。 2. 数据库名错误：请确保您正在使用的数据库中存在该表。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

最强玩者

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值