Do these steps:
- open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini
- look up for:
# The MySQL server [mysqld]
- add this right below it:
lower_case_table_names = 2
- save the file and restart MySQL service
From: http://webdev.issimplified.com/2010/03/02/mysql-on-windows-force-table-names-to-lowercase/
Related Contents:
- How to solve “Error: MySQL shutdown unexpectedly”?
- xampp MySQL does not start
- How can I access the MySQL command line with XAMPP for Windows?
- MySQL error 1064 syntax but everything seems fine
- What is the location of mysql client “.my.cnf” in XAMPP for Windows?
- MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
- How can I change MariaDB to MySQL in XAMPP?
- How to turn on/off MySQL strict mode in localhost (xampp)?
- Search text in fields in every table of a MySQL database
- Which MySQL data type to use for storing boolean values
- How to split the name string in mysql?
- MySQL – How to unpivot columns to rows?
- MySQL string replace
- What is the difference between utf8mb4 and utf8 charsets in MySQL?
- Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
- Is there a MySQL option/feature to track history of changes to records?
- Get table names using SELECT statement in MySQL
- MySQL Update Inner Join tables query
- Find distance between two points using latitude and longitude in mysql
- Get current AUTO_INCREMENT value for any table
- Setting up MySQL and importing dump within Dockerfile
- Does MySQL index foreign key columns automatically?
- Why does MySQL allow “group by” queries WITHOUT aggregate functions?
- Run MySQLDump without Locking Tables
- MySQL: multiple tables or one table with many columns? [closed]
- How to remove accents in MySQL?
- MySQL utf8mb4, Errors when saving Emojis
- MySQL stored procedure vs function, which would I use when?
- Mysql localhost != 127.0.0.1?
- MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
- How to get the latest record in each group using GROUP BY? [duplicate]
- SQL Selecting from two Tables with inner join and limit [duplicate]
- How to get the difference in years from two different dates?
- How to export data from SQL Server 2005 to MySQL [closed]
- MySQL SELECT last few days?
- Update a column in MySQL
- Is there a simple way to convert MySQL data into Title Case?
- Illegal mix of collations error in MySql
- passing LIMIT as parameters to MySQL sproc
- Set value to NULL in MySQL
- Sort the rows according to the order specified in WHERE IN clause
- How can write queries in MySQL that can parse JSON data in a column?
- MySQL : retrieve a large select by chunks
- Mysql delete statement with limit
- MySQL LOAD_FILE() loads null values
- How to determine which database is selected
- Dump only the data with mysqldump without any table information?
- Convert datetime value into string
- mysql – move rows from one table to another
- Node.js returning result from MySQL query