Shulou(Shulou.com)06/01 Report--

The editor will share with you how to set case sensitivity in Windows Mysql8. I hope you will gain a lot after reading this article. Let's discuss it together.

Windows system mysql8.0 change lower_case_table_names

Yesterday I searched on Baidu. It hasn't been solved for 7 hours, but it will be solved by searching on google for 1 hour today. Let me tell you slowly.

First of all, because I want to write games in kbengine, I go to kbengine and find that it requires the lower_case_table_names of MySQL to be 0. So began to make a long change.

1. In fact, the windows system cannot be changed to lower_case_table_names=0, because windows defaults to 1, and even if it is changed, it can only be changed to 2. The following is cut from MySQL 8.0 Reference Manual

2. Then, when we forcibly change the lower_case_table_names in my.ini to 2 according to the online method, we will find that mysql server cannot be started! This is because (or MySQL 8.0 Reference Manual)

You will see that the error is that your data file defaults to 1, but your lower_case_table_names=2 is wrong. Mysql8.0 requires that we cannot change the value of lower_case_table_names after initialize, so the right thing to do is!

1. Empty the data file. My data file is in programdata\ MySQL\ XXXXserver 8.0\. Just delete it and put it back empty.

2. Then change the lower_case_table_names in my.ini and directly change 1 to 2

3. Then run cmd as an administrator

Do this to re-initialize mysql server

4. Then... Your mysql server will be re-initialize.

Follow-up:

Because it's re-initialize... The old stuff is gone... So, when you log in to mysql again, the user name is root, and the password searches for a .err file in programdata\ MySQL\ XXXXserver 8.0\. The password will be initialized randomly inside, and you can log in with this password. It would be nice to change him later.

After reading this article, I believe you have a certain understanding of how to set case sensitivity in Windows Mysql8. Want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.