架构师之路--linux安装sql server2019

安装

1.设置sqlserver安装镜像

curl https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo > /etc/yum.repos.d/mssql-server.repo

2.执行安装

yum install -y mssql-server

配置

sudo /opt/mssql/bin/mssql-conf setup

1，版本选择 developer
2，同意条款 yes
3，输入两次密码 123456
4，打开防火墙

firewall-cmd --zone=public --add-port=1433/tcp --permanent
firewall-cmd --reload

命令

systemctl start mssql-server
systemctl restart mssql-server
systemctl stop mssql-server
systemctl status mssql-server

更换端口

如果替换mysql的端口:
停止msql

service mysqld stop

替换端口

sudo /opt/mssql/bin/mssql-conf set network.tcpport 3306

重启sql server

sudo systemctl restart mssql-server