达梦数据库RPM安装步骤

达梦数据库安装步骤

1、基础软件RPM包安装

rpm -ivh dmdbms-8.2-1.aarch64.rpm

[root@localhost DM8-飞腾银河麒麟版-rpm]# rpm -ivh dmdbms-8.2-1.aarch64.rpm
Verifying...                          ################################# [100%]
准备中...                          ################################# [100%]
正在升级/安装...
   1:dmdbms-8.2-1                     ################################# [100%]
Created symlink /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service → /etc/systemd/system/DmServiceDMSERVER.service.
Created symlink /etc/systemd/system/multi-user.target.wants/DmAPService.service → /etc/systemd/system/DmAPService.service.

2、数据库初始化

/opt/dmdbms/bin/bin/dminit   PATH=/opt/dmdbms/bin/data

3、数据库启动

/opt/dmdbms/bin/bin/dmserver   /opt/dmdbms/bin/data/DAMENG/dm.ini

4、本机数据库连接

 /opt/dmdbms/bin/bin/disql  SYSDBA/SYSDBA@LOCALHOST:5236

5、新建用户张三

create user zhangsan;

授权 dba权限

grant dba to zhangsan;

6、切换审计并给新建用户设置密码

 /opt/dmdbms/bin/bin/disql  SYSSSO/SYSSSO@LOCALHOST:5236

alter user `zhansgan` identified by "!QAZ1qaz" (密码为复杂密码)

数据库维护

• 使用SYSSSO用户修改zhangsan用户密码7天过期：

alter user "zhangsan" limit password_life_time unlimited

• 修改zhangsan用户口令过期时间限制：

alter user "zhangsan" limit failed_login_attemps  unlimited;

• 修改zhangsan用户失败登录次数限制：

alter user "zhangsan" limit  password_life_time  unlimited;

5、修改zhangsan用户口令锁定限制：

alter user "zhangsan" limit password_lock_time  unlimited;

alter user SYSDBA limit password_life_time unlimited;

alter user SYSSSO limit password_life_time unlimited;