在mi.ini中[mysqld]处添加lower_case_table_names=2
[mysqld]
lower_case_table_names=2
附 安装相关命令
管理员身份cmd 进入C:\lib\mysql-8.0.28-winx64\bin
mysqld --initialize --console
mysqld -install
net start mysql
mysql -uroot -p
alter user ‘root’@‘localhost’ identified by ‘想要设置的密码’;
create database test;
use test;
create table Dx(id int(11));
show tables;
mysql密码忘记:
删除mysql服务
sc delete mysql
删除C:\lib\mysql-8.0.28-winx64\data
mysqld --initialize --console