Linux 安装mysql8 修改lower

备份原有的数据库sql文件卸载原有的数据库

dpkg --list|grep mysql

sudo apt-get remove mysql-common
sudo apt-get autoremove --purge mysql-server
sudo apt-get autoremove --purge mysql-apt-config

重新安装mysql

从官网下载对应的安装包.deb

sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

sudo apt-get upgrade

[mysqld]
 
lower_case_table_names = 1

sudo apt install mysql-server

选择Use Strong Password Encryption (RECOMMENDED)

systemctl start mysql

CREATE USER ‘root’@’%’ IDENTIFIED BY ‘Hadoop3!’;
grant all privileges on . to ‘root’@’%’;
alter user ‘root’@’%’ identified with mysql_native_password by ‘Hadoop3!’;
flush privileges;