mysql相关

1. mysql修改存储路径

默认在/var/lib/mysql下，移动目录并修改/etc/my.cnf
https://blog.51cto.com/u_15328720/3436675

（1）移动完之后报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-rIHXRgQL-1653048739663)(evernotecid://F288BDDC-BC14-4C39-9CD9-05F58DDE9184/appyinxiangcom/26643962/ENResource/p216)]

在原来的位置下建个软链，软链到新的位置下就行了

1.3 创建分区的语句

CREATE TABLE `tr2` (       `id` INT,        `name` VARCHAR(50),        `purchased` DATE     ) ENGINE=InnoDB DEFAULT CHARSET=utf8     PARTITION BY RANGE( YEAR(purchased) ) (     PARTITION p0 VALUES LESS THAN (2022)     ); 


CREATE TABLE `tr2` (       `id` INT,        `name` VARCHAR(50),        `purchased` DATE     ) ENGINE=InnoDB DEFAULT CHARSET=utf8     PARTITION BY RANGE( to_days(purchased) ) (     PARTITION p0 VALUES LESS THAN (2022)     ); 

1.4 查看mysql的history
cat ~/.mysql_history
https://blog.51cto.com/u_2853725/1377345