mysql session大小写_mysql 8 设置大小写不敏感

停业务服务。

备份数据

停库

# systemctl stop mysqld

修改配置

删文件：

# rm /var/lib/mysql/* -rf

启动：

# systemctl start mysqld

设置密码等级

mysql> set global validate_password.policy=0;

Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password.length=1;

Query OK, 0 rows affected (0.00 sec)

修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

Query OK, 0 rows affected (0.00 sec)

设置root远程访问

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 host,user from user;

+-----------+------------------+

| host | user |

+-----------+------------------+

| localhost | mysql.infoschema |

| localhost | mysql.session |

| localhost | mysql.sys |

| localhost | root |

+-----------+------------------+

4 rows in set (0.00 sec)

mysql> update user set host='%' where user='root';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> select host,user from user;

+-----------+------------------+

| host | user |

+-----------+------------------+

| % | root |

| localhost | mysql.infoschema |

| localhost | mysql.session |

| localhost | mysql.sys |

+-----------+------------------+

4 rows in set (0.00 sec)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

10.查看大小写敏感

11. 重启数据库

systemctl restart mysqld

12.创建库名称

导入数据