ubuntu操作系统安装mysql8数据库表名设置大小写不敏感

# 更新软件包
sudo apt-get update

# 安装mysql
sudo apt-get install -y mysql-server

# 停止mysql
sudo systemctl stop mysql

# 备份配置文件
sudo cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf.backup

# 卸载已安装的MySQL
sudo apt-get --purge autoremove mysql-server -y

# 删除相关内容
sudo rm -rf /var/lib/mysql

# 提前复制备份的配置文件到安装目录
sudo cp /etc/mysql/mysql.conf.d/mysqld.cnf.backup /etc/mysql/mysql.conf.d/mysqld.cnf

# 修改配置文件
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

# 在mysqld[]标签下添加一行：lower_case_table_names = 1

# 再次执行安装命令
sudo apt-get install -y mysql-server

#这个时候会提示mysqld.cnf已存在，是否覆盖，输入N（默认也是N）

安装完成后进入数据库：

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select @@lower_case_table_names;
+--------------------------+
| @@lower_case_table_names |
+--------------------------+
|                        1 |
+--------------------------+
1 row in set (0.00 sec)

mysql>