mysql8修改密码

2020-01-12

1 分钟阅读 (38 字)

bash

1
2

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

优化mysql占用的内存

bash

vim /etc/mysql/mysql.conf.d/mysqld.cnf

toml

[mysqld]
performance_schema_max_table_instances=400  
table_definition_cache=400  
table_open_cache=256
performance_schema = off

重启mysql

bash

systemctl restart mysql