MySQL8.0的坑之lower_case_table_names
在安裝了8.0.14之後,初始化的時候在my.cnf裡設定了lower_case_table_names=1,安裝好了之後,啟動報錯:
2019-01-28T13:24:24.919463+08:00 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.14) starting as process 24567 2019-01-28T13:24:25.339412+08:00 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0'). 2019-01-28T13:24:25.339709+08:00 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2019-01-28T13:24:25.339903+08:00 0 [ERROR] [MY-010119] [Server] Aborting 2019-01-28T13:24:26.660278+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.14) MySQL Community Server - GPL.
檢視MySQL官方文件,有記錄:
lower_case_table_names can only be configured when initializing the server. Changing the lower_case_table_names setting after the server is initialized is prohibited.
只有在初始化的時候設定 lower_case_table_names=1才有效,比如:
--initialize --lower-case-table-names=1
詳見
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20893244/viewspace-2565069/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL8.0之XtraBackupMySql
- MySQL8.0變化之密碼策略MySql密碼
- iOS之UIWebView的坑iOSUIWebView
- MySQL8.0之跳躍範圍掃描MySql
- mysql 大小寫敏感 lower_case_table_namesMySql
- mysql8.0插入慢之sync_binlog(一)MySql
- 開發遇到的坑之blockBloC
- 小白之 Gin 安裝遇到的坑
- SpringBoot的Cookie sameSite之坑Spring BootCookie
- Angular之ngSwitch踩坑Angular
- golang—踩坑之切片Golang
- MYSQL8.0安裝MySql
- Mysql8.0 報錯MySql
- 小程式的填坑小技巧之CanvasCanvas
- uniapp之那些年踩過的坑APP
- C++之那些年踩過的坑C++
- [iOS]貝聊 IAP 實戰之見坑填坑iOS
- MySQL8.0中role的使用實踐MySql
- 升級MySQL8.0的歷險記MySql
- MySQL8.0的自動部署指令碼MySql指令碼
- python複製之坑Python
- 正則之坑知多少
- vue系列之踩坑之旅Vue
- Opengl ES之踩坑記
- rust入坑指南之ownershipRust
- docker拾遺-之再入坑Docker
- Mac 安裝 MySQL8.0MacMySql
- mysql8.0修改密碼MySql密碼
- Docker 安裝 MySQL8.0DockerMySql
- MySQL8.0效能優化MySql優化
- MySQL8.0初體驗MySql
- MySQL8.0:The General Query LogMySql
- MySQL8.0新特性-臨時表的改善MySql
- MySQL8.0 view導致的效能問題MySqlView
- eureka踩過的坑之註冊服務相互之間呼叫
- [貝聊科技]貝聊 IAP 實戰之見坑填坑
- GORM之ErrRecordNotFound採坑記錄GoORM
- MySQL 之 LEFT JOIN 避坑指南MySql