安装mysql8并忽略大小写

安装mysql8并忽略大小写

1.卸载MariaDB

sudo pacman -Rsc mariadb

2.安装mysql

sudo pacman -S mysql

3.初始化mysql

sudo /usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1

在my.cnf添加lower-case-table-names
4.用初始密码登录

mysql -uroot -p

5.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY "new password";

开放远程访问:

use mysql;
update user set host = '%' where user ='root';
flush privileges;