novice的博客

k8s pv pvc NAS EBS 块设备

1. mysql 数据库 修改默认时区 1.1 自建mysql a. 修改当前会话时区，临时生效，退出msql后 time_zone 恢复成修改前的值 set time_zone = '+8:00'; 修改 /etc/mysql/my.cnf b. 修改全局会话时区 mysql> set global time_zone = '+8:00'; mysql> set time_zone = '+8:00'; mysql> flush privileges; c. 通过修改配置文件(my.

1. 添加root用户并赋予权限 use mysql; create user 'root'@'%' identified by '123456'; grant all on *.* to root@'%' identified by '123456'; 2. mysql查看当前所有数据库大小 select table_schema, concat(truncate(sum(data_length)/1024/1024,2),' mb') as data_size,concat(truncate(s