MySQL error 1146 tabel doen ' t exist errors caused by case sensitive problem _mysql

Source: Internet
Author: User
Tags phpmyadmin

MYSQL Error 1146 tabel doen ' t exist, in general, the table does not exist, or the table name is wrong, permission issues.

Today encountered this problem, carefully check several times, confirm the correct, and in the phpMyAdmin to try Select, you can query the data. Also check the permissions to confirm that the MySQL user has all the permissions. What about this mistake? After querying for some information, it was found that if the MySQL engine was not correct, it would be inaccessible to a real-life table, but the engine was MyISAM.

This is a worry, where is the error? Looking for a long time, still no fruit. Innocent look at this section of the error code, a daze for a half-day, suddenly found a detail that has been overlooked by me, detailed error code for tabel ABC doen ' t exist, where the table name is uppercase, and the table in the database named ABC (horse Winter Note: For example, no this table), is lowercase. In phpMyAdmin, an uppercase table named ABC tries to select, and the error prompts tabel ABC Doen ' t exist.

Here, the problem is clearly visible, because of a problem I overlooked: Under Windows Server, MySQL's data tables are case-insensitive, while Linux servers are case-sensitive by default. If the Linux server is to be modified to be case insensitive, you can find/etc/my.cnf and add a line under [mysqld]: Lower_case_table_names=1. (Horse winter Note: Lower_case_table_names By default is 0, and table name is case sensitive, modified to 1, that is, case insensitive). If you do not have permission to modify the server configuration, be aware that each table name that appears will be case-sensitive.

Not paying attention to small details often wastes a lot of time. Details determine success or failure.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.