oracle
安装oracle时需要的所需的软件包安装命令
yum install binutils* compat-libcap1* gcc* glibc* ksh libaio* libgcc* libstdc++* libXi* libXtst* make* sysstat*
1 建用户create user oracle(用户名) identified by password(密码是数字时加引号);
2 grant resource,connect, dba to oracle(用户名); 加权限
3 oracle登录用户
Connect oracle/123456(用户名/密码)
4 建表
create table test(id number(2) not null,name varchar(20),age number(2),ach number(2));
5 远程登陆mysql
远程登录oracle数据库[oracle@localhost ~]$ sqlplus oracle/123456@//10.0.0.79:1521/orc
Mysql
修改mariadb的root密码
use mysql;
update user set password = PASSWORD('123456') where user = 'root';
1 增加用户并授权的命令mysql
grant select,insert,update,delete on *.* to "sys"@"%" identified by "123";
2 mysql 远程授权
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
Flush privileges;
window改mysql数据库的密码的命令
Set password for 'root'@'localhost' = password('yudun*2017');
以utf8格式导出数据库和结构
mysqldump -hlocalhost -P3306 -uroot -pyudun*2017 netgap_conf --default-character-set=utf8 > /opt/systool/conf/netgap_conf_in.sql