linux ubuntu mysql5.7.25安装 lower_case_table_names修改

 
sudo apt-get update
apt-get upgrade
 
apt-get install libaio1
sudo apt-get -f install
sudo apt autoremove
wget https://repo.mysql.com//mysql-apt-config_0.8.12-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb 
 
sudo apt-get update
sudo apt-get install mysql-server
 
 
 
mysql -h127.0.0.1 -u root -p
 
mysql> show variables like 'lower%';
 
mysql> exit
 
 
service mysql stop
 
vim /etc/mysql/mysql.conf.d/mysqld.cnf
 
service mysql start
 

mysql -h127.0.0.1 -u root -p
 
 
mysql> show variables like 'lower%';