MSSQL for linux 安装

发表于 | 更新于 | 分类于

https://packages.microsoft.com/config/rhel/7/
mssql地址

  • 获取yum源
1
[root@yth-test bin]# curl https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo >/etc/yum.repos.d/mssql-server.repo
  • 安装MSSQL
1
2
3
[root@yth-test bin]# yum install mssql-server
[root@yth-test bin]# cd /opt/mssql/bin
[root@yth-test bin]# ./mysql-conf setup
  • 查看服务状态
1
systemctl status mssql
  • 安装工具
1
2
3
4
5
[root@yth-test bin]# curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/prod.repo
[root@yth-test bin]# yum install mssql-tools
[root@yth-test bin]# pwd
/opt/mssql-tools/bin
[root@yth-test bin]# ./sqlcmd -S localhost -U sa