MySQL8.0 表名大小写 lower-case-table-names

mysql8处理lower-case-table-names=1

1. 在安装mysql之前创建/etc/mysql/mysql.conf.d/lower.cnf
[mysqld]
lower-case-table-names=1

2. 安装mysql
   sudo apt-get install mysql-server -y
   sudo apt install mysql-client  -y
   sudo apt install libmysqlclient-dev -y

3. 验证mysql安装是否成功
    sudo netstat -tap | grep mysql 

4. 登录 mysql -uroot -p   登录失败    
    sudo cat /etc/mysql/debian.cnf 来查找默认用户名密码
    mysql -udebian-sys-maint -p

mysql>use mysql;
mysql>flush privileges;
mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
mysql>flush privileges;
mysql> select host, user, authentication_string, plugin from user;

mysql> create user 'root'@'%' identified by '123456';
mysql> grant all privileges on *.* to 'root'@'%';
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
mysql> flush privileges;

5. mysql配置文件中把 127.0.0.1 那行注释掉
     sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

6. 重启mysql服务
     sudo service mysql restart