启动MySQL后配置大小写会无法重启MySQL需要先删除/var/lib/mysql(注意备份会删除所有表)
sudo service mysql stop
rm -rf /var/lib/mysql
修改配置文件
vim /etc/mysql/mysql.conf.d/mysqld.cnf
添加
lower_case_table_names=1
重启MySQL
sudo service mysql start
登录MySQL
mysql -uroot -p 123456
use mysql;
update user set plugin='mysql_native_password' where user='root';
update user set user.Host='%' where user.User='root';
flush privileges;
ALTER USER 'root'@'%' IDENTIFIED BY '密码';
flush privileges;
查找MySQL安装路径
whereis mysql
root@iZuf6jaz33icbo7l90vr1wZ:/etc/mysql/mysql.conf.d# whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /etc/mysql /usr/share/man/man1/mysql.1.gz