SQL Server

1.下载 Microsoft SQL Server 2019 Red Hat 存储库配置文件
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

备份yum.repos.d，执行如下
curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo
sudo yum makecache

2.运行以下命令以安装 SQL Server
sudo yum install -y mssql-server

3.包安装完成后，运行 mssql-conf setup，按照提示设置 SA 密码并选择版本
sudo /opt/mssql/bin/mssql-conf setup

4.完成配置后，验证服务是否正在运行
systemctl status mssql-server

安装 SQL Server 命令行工具
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/8/prod.repo
sudo yum install -y mssql-tools unixODBC-devel
将/opt/mssql-tools/bin/添加到环境变量
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

sqlcmd -H 127.0.0.1 -U sa
sqlcmd -S localhost -U SA -P 'Bao12345'

查看数据库
SELECT Name from sys.Databases
go

创建数据库
CREATE DATABASE sb

查看用户
select name from sysusers;
go

停止服务
systemctl stop mssql-server
启动服务
systemctl start mssql-server
重启服务
systemctl restart mssql-server
随系统自动启动
sudo systemctl enable mssql-server

修改数据库默认端口（默认端口为1433）
/opt/mssql/bin/mssql-conf set network.tcpport 5500

防火墙放行修改的端口 （云服务器添加入站规则即可）
firewall-cmd --zone=public --add-port=5500/tcp --permanent
firewall-cmd --reload

SQL Server版本
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.