安装sql server 2019
下载地址：
https://packages.microsoft.com/rhel/7/mssql-server-2019/
安装包：
mssql-server-15.0.4003.23-3.x86_64.rpm
msodbcsql17-17.4.1.1-1.x86_64.rpm
mssql-tools-17.4.1.1-1.x86_64.rpm
rpm -ivh mssql-server-15.0.4003.23-3.x86_64.rpm
rpm -ivh msodbcsql17-17.4.1.1-1.x86_64.rpm
rpm -ivh mssql-tools-17.4.1.1-1.x86_64.rpm
#配置
/opt/mssql/bin/mssql-conf setup
#选3，选express版本
Choose an edition of SQL Server:
1) Evaluation (free, no production use rights, 180-day limit)
2) Developer (free, no production use rights)
3) Express (free)
4) Web (PAID)
5) Standard (PAID)
6) Enterprise (PAID) - CPU Core utilization restricted to 20 physical/40 hyperthreaded
7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum
8) I bought a license through a retail sales channel and have a product key to enter.
echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh
source !$
#防火墙添加服务
firewall-cmd --permanent --add-service=mssql
firewall-cmd --reload
#修改端口（办公网段1433端口被屏蔽）
/opt/mssql/bin/mssql-conf set network.tcpport 11433
#重启
systemctl restart mssql-server.service
#命令行连接测试
sqlcmd -S 172.16.16.XX:11433
# 显示系统数据库
1> select name,database_id from sys.databases;
# 执行
2> go
name database_id
-------------------------------------------------------------------------------------------------------------------------------- -----------
master 1
tempdb 2
model 3
msdb 4
(4 rows affected)
# 查看软件版本
1> SELECT @@VERSION
2> go
Sybase 15.7安装
#离线安装导入镜像
docker load -i sybase157.tar
#创建容器，等30秒
docker run -d -t -p 5000:5000 -e "SYBASE_USER=guest" -h dksybase --name sybase157 chernov/sybase:latest
#安装 pubs2 test database
docker exec -t sybase157 /bin/bash /sybase/isql -i"/opt/sybase/ASE-15_0/scripts/installpubs2"
#查看日志
docker logs [containerid]
mongodb 安装
1.解压，创建软连接
tar -zxvf mongodb-linux-x86_64-3.4.6.tgz.gz
cd /data/software/
mkdir mongodb
ln -s /data/software/mongodb-linux-x86_64-3.4.6 /data/software/mongodb
cd mongodb
mkdir -p data/db
chmod 777 -r data/db
mkdir logs
cd logs
touch mongodb.log
2.配置系统profile
vi /etc/profile
export MONGODB_HOME=/data/software/mongodb
export PATH=$PATH:$MONGODB_HOME/bin
3.mogodb.conf 配置文件
vi /data/software/mongodb/bin/mongodb.conf
dbpath = /data/software/mongodb/data/db
logpath = /data/software/mongodb/logs/mongodb.log
port = 27018
fork = true
nohttpinterface = true
bind_ip = 0.0.0.0
auth=false
logappend = true
4.启动
./mongod -f mongodb.conf
5.配置
#连接
./mongo 127.0.0.1:27018
#创建用户
use admin
db.createUser({ user: "admin", pwd: "XXX", roles: [{ role: "userAdminAnyDatabase", db: "admin" }] })
db.createUser({user: "root",pwd: "XXX", roles: [ { role: "root", db: "admin" } ]})
#验证
db.auth("root","Rt@20201207")
#关闭
db.shutdownServer()
6.开启鉴权并启动
vi /data/software/mongodb/bin/mongodb.conf
#修改配置项
auth=true
./mongod -f mongodb.conf
参考文档：
https://blog.csdn.net/topswim/article/details/86613507
https://blog.csdn.net/Aria_Miazzy/article/details/85229736
https://blog.csdn.net/u014389734/article/details/103952326
https://www.cnblogs.com/lemon-flm/p/11052449.html
https://www.jianshu.com/p/62736bff7e2e
