标签：DataBases - 运维之路

MySQL创建账号、授权

1.创建新用户 CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; 2.授权该用户对所有数据库的所有权限 GRANT ALL PRIVILEGES ON database.* TO 'newuser'@'localhost'; 3.

DataBases MySQL

Linux服务器，MySQL8.0.33升级到MySQL8.0.34

Linux服务器，MySQL8.0.33升级到MySQL8.0.34 注意：升级之前做好软件和数据双重备份！！！ 1.在MySQL官网下载当前MySQL对应的高版本安装包 2.解压安装包 tar zxvf mysql-8.0.34-linux-glibc2.12-x86_64.tar.gz

DataBases MySQL 漏洞修复

Oracle创建表空间

1.创建临时表空间 create temporary tablespace user_temptempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'size 50mautoextend onnext 50m maxsize 20480mextent m

DataBases Oracle

Oracle生成随机小写不重复的UUID

LOWER(RAWTOHEX(sys_guid()))

DataBases Oracle

MySQL定时全量备份数据

https://mp.weixin.qq.com/s/I4tLPuzcnHMA9crChDXEeQ

DataBases MySQL

MySQL定时增量备份数据

https://blog.csdn.net/zone_/article/details/81321431?spm=1001.2101.3001.6650.2&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%

DataBases MySQL