mysql8.0大小写不敏感配置

最新推荐文章于 2026-05-18 08:34:14 发布

原创最新推荐文章于 2026-05-18 08:34:14 发布 · 126 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#mysql

收录于

1.systemctl stop mysqld

2.rm -rf /var/lib/mysql

3.mysqld --initialize \
  --user=mysql \
  --basedir=/usr \
  --datadir=/var/lib/mysql \
  --lower_case_table_names=1

4.chown -R mysql:mysql /var/lib/mysql

5.[mysqld]
  lower_case_table_names=1  # 必须与初始化时的参数一致
  datadir=/var/lib/mysql
  socket=/var/lib/mysql/mysql.sock
  log-error=/var/log/mysqld.log
  pid-file=/var/run/mysqld/mysqld.pid
  bind-address=0.0.0.0

6.systemctl start mysqld

7.查看临时密码
  grep 'temporary password' /var/log/mysqld.log

8.使用临时密码登录

9.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPass@123';  # 示例密码
FLUSH PRIVILEGES;  # 刷新权限

10.查看大小写配置
  show variables like 'lower_case_table_names';