linux:mysql
MySQL
Installation
percona mysql server
Usage
允许远程访问
GRANT ALL PRIVILEGES ON db.* TO 'root'@'host' IDENTIFIED BY 'password';
修改密码
-- SET GLOBAL validate_password_policy=LOW; SET PASSWORD = PASSWORD('your password');
Optimization
MySQL CPU 占用率高
使用以下命令查询当前的 SQL 查询:
SHOW FULL processlist;
linux/mysql.txt · 最后更改: 2023/12/03 10:24 由 127.0.0.1