centos下mysql8 lower_case_table_names=1

友林

如题,如何修改lower_case_table_names=1的设定

问题比较着急?请联系QQ:760483
  • Peter·Python
  • Peter·Python    2020-10-26 15:10:311楼

    重新初始化数据库

    +添加回复

  • 回复

    mysqld --initialize --user=root --lower-case-table-names=1 使用这个命令初始化过 好像没啥反应

    友林  作者 · 2020-10-26 16:24:26
    回复

    执行应该成功了 [mysql-8.0.16]#mysqld --initialize --user=root --lower-case-table-names=1 2020-10-26T07:57:20.780160Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2020-10-26T07:57:20.780173Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2020-10-26T07:57:20.780572Z 0 [System] [MY-013169] [Server] /usr/local/phpstudy/soft/mysql/mysql-8.0.16/bin/mysqld (mysqld 8.0.16) initializing of server in progress as process 17485 2020-10-26T07:57:24.026620Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: *lSrir:gV59q 2020-10-26T07:57:25.020821Z 0 [System] [MY-013170] [Server] /usr/local/phpstudy/soft/mysql/mysql-8.0.16/bin/mysqld (mysqld 8.0.16) initializing of server has completed

    友林  作者 · 2020-10-26 16:26:03
    回复