Windows Mysql8 sets case sensitivity

windows system mysql8.0 change lower_case_table_names

I searched on Baidu yesterday...I didn’t solve it for 7 hours. Today I went to Google and searched for 1 hour and the solution was solved...Let me slowly explain Come...

First of all, because I want to use kbengine to write games, I went to kbengine and found that it requires MySQL's lower_case_table_names to be 0...So I started a long change...

1. In fact, the windows system cannot be changed. into lower_case_table_names=0, because the default value of windows is 1, even if it is changed, it can only be changed to 2. The following is taken from the MySQL 8.0 Reference Manual

2. Then, when we follow the online Method: After forcibly changing lower_case_table_names in my.ini to 2, you will find that mysql server cannot be started! ! This is because (the following is still MySQL 8.0 Reference Manual)

You will see the error is that your data file defaults to 1, but your lower_case_table_names=2, so an error is reported. Mysql8.0 requires that we cannot change the value of lower_case_table_names after initialize, so the correct approach is! ! !

1. Clear the data file. My data file is in programdata\MySQL\XXXXserver 8.0\. Just delete it and put an empty one again.

2. Then put my In lower_case_table_names in .ini, directly change 1 to 2

3, then run cmd as administrator,

Do this step to re-initialize mysql server

4. Then...your mysql server will be re-initialized

Follow-up:

Because it was re-initialized...the previous things are gone...So, you log in to mysql again At that time, the username is root, and the password is searched for an .err file in programdata\MySQL\XXXXserver 8.0\. The password will be randomly initialized in it. You can log in with this password. You can just change him later

The above is the detailed content of Windows Mysql8 sets case sensitivity. For more information, please follow other related articles on the PHP Chinese website!