Little Star Blog

路在脚下，心向远方

Mariadb+Keppalived互为主备

假设现在有两台服务器，需要搭建Mariadb高可用性集群，一台为主数据库（Master），另一台为从数据库（Slave）。服务器信息如下： 服

Posted by     "lxg" on Saturday, April 12, 2025

PostgreSQL 用户管理

创建用户 修改用户密码 删除用户

Posted by     "lxg" on Thursday, August 22, 2024

OpengaussDB

创建数据库 CREATE DATABASE collector WITH ENCODING 'utf8'

Posted by     "lxg" on Wednesday, August 21, 2024

sybase

表操作 创建表 create table dbo.table_name ( column_name int) 删除表 drop table table_name 删除数据 delete from table_name

Posted by     "lxg" on Wednesday, August 21, 2024

sybase

登录数据库 /sybase/isql -S DKSYBASE -U sa -P password 用户操作 创建用户 create login xxx with password wewewew@2323 修改用户密码 alter login xxx with password 'password' modify password 'wewewWWD#$ew@23233'

Posted by     "lxg" on Wednesday, August 21, 2024

sybase

docker安装 https://hub.docker.com/r/chernov/sybase docker run -d -t -p 5000:5000 -e "SYBASE_USER=guest" -h dksybase --name sybase157 chernov/sybase:latest docker exec -t sybase157 /bin/bash /sybase/isql -i"/opt/sybase/ASE-15_0/scripts/installpubs2" 分页显示 设置返回条数 不限制 SET ROWCOUNT 0 返回4条 SET ROWCOUNT 4 显示前4条内容 SELECT TOP 4 t.* from table_name t 查看设备

Posted by     "lxg" on Wednesday, August 21, 2024

sybase 审计操作

打开审计攻击 查看当前审计状态 sp_configure 'auditing' 打开审计 第一步、先初始化审计设备 disk init name = "auditdev", physname = "/opt/sybase/data/c2d0s4", size = "100M" disk init name = "auditlogdev", physname = "/opt/sybase/data/c2d0s5", size = "200M" create database sybsecurity on auditdev log on auditlogdev 第二步、执行审计

Posted by     "lxg" on Wednesday, August 21, 2024

PostgreSQL 审计操作

查看插件 select name from pg_available_extensions; 查看pgaudit设置 select name,setting from pg_settings where name ~ 'pgaudit'; set pgaudit.log = 'write, ddl'; set pgaudit.log_relation = on; pgaudit.log 可选项如下 参数值 描述 none 这是原定设置值。不记录任何数据库更改。 all 记录

Posted by     "lxg" on Sunday, August 18, 2024

SQL Server 常用命令

常用操作 修改SA账号的密码（基于sql） ALTER LOGIN [sa] WITH PASSWORD=N'newpassword' 以上均只供测试环境调试使用，线上谨慎使用。

Posted by     "lxg" on Monday, August 12, 2024

Mysql Database 常用命令

主从问题 show slave status查看同步出现异常 使用skip 跳过一定数量的事务，先让他同步起来，后面再数据修复 SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;

Posted by     "lxg" on Monday, August 5, 2024

Mysql Database 常用命令

常用命令 登陆数据库 登陆远程地址为xx端口为3307用户为root mysql -u root -h xx -p -P 3307 用户权限相关 查看用户相关配置 ALTER USER 'root'@'%' IDENTIFIED BY 'new_password'; 修改密码 set password for root@localhost = password('123');

Posted by     "lxg" on Monday, August 5, 2024

Oracle Database 审计操作

安装oracle https://hub.docker.com/r/dragonbest520/oracle-xe-10g 查询是否开启审计 show parameter audit; 使用ssh登陆 ssh root@localhost -p 49160 password: admin 开启审计 alter system set audit_sys_operations=TRUE scope=spfile; alter system set audit_trail=DB scope=spfile; alter system set audit_trail=db,extended scope=spfile; 查看审计结果 select username 用户,action_

Posted by     "lxg" on Monday, August 5, 2024

Oracle Database 常用命令

常用操作 用户相关 创建表空间以新用户 重启数据库实例 shutdown immediate; startup mount; alter database open; 创建表空间 CREATE TABLESPACE lxg DATAFILE 'F:\tablespace\demo' size 800M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 创建索引表空间 CREATE TABLESPACE lxg_index DATAFILE 'F:\tablespace\demo' size 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT

Posted by     "lxg" on Monday, August 5, 2024

Oracle Database 用户相关

使用sysdba登陆 sqlplus sys/oracle as sysdba 查询DBA权限用户 select GRANTEE as username,admin_option from dba_role_privs where GRANTED_ROLE='DBA' 使用账号密码登录 sqlplus username/password 如：普通用户登录 sqlplus scott/tiger sqlplus username/password as sysdba 如：sqlplus sys/admin as sysdba sqlplus username/password@net_service_name 如

Posted by     "lxg" on Monday, August 5, 2024

avatar

Software Developer, Open Source Enthusiast and Life Adventurer

QUICK LINKS
FEATURED TAGS
ebpf lvm mysql oracle postgresql sybase ubuntu 分区 审计 性能测试 数据库 磁盘 经济 网络 软考笔记
FRIENDS