第 4 步:在 Ubuntu 20.04/18.04/16.04 LTS 上安装 MS SQL Server 2019
现在运行以下命令来安装 SQL Server:
1 2
sudo apt update sudo apt install mssql-server
按y 键在 Ubuntu 20.04/18.04/16.04 上开始安装 Microsoft SQL Server 2019。
1 2 3 4 5 6 7 8 9 10 11 12
Recommended packages: libc-dbg libcc1-0 gdbserver The following NEW packages will be installed: gawk gdb libbabeltrace1 libc++1 libc++1-10 libc++abi1-10 libdw1 libmpfr6 libpython2-stdlib libpython2.7-minimal libpython2.7-stdlib libsasl2-modules libsasl2-modules-gssapi-mit libsigsegv2 libsss-nss-idmap0 mssql-server python-is-python2 python2 python2-minimal python2.7 python2.7-minimal 0 upgraded, 21 newly installed, 0 to remove and 9 not upgraded. Need to get 235 MB of archives. After this operation, 1,101 MB of additional disk space will be used. Do you want to continue? [Y/n] y
.... Unpacking mssql-server (15.0.4033.1-2) ... Setting up libdw1:amd64 (0.176-1.1build1) ... Setting up gawk (1:5.0.1+dfsg-1) ... Setting up libsasl2-modules:amd64 (2.1.27+dfsg-2) ... Setting up libpython2.7-stdlib:amd64 (2.7.18~rc1-2) ... Setting up libbabeltrace1:amd64 (1.5.8-1build1) ... Setting up libc++abi1-10:amd64 (1:10.0.0-4ubuntu1) ... Setting up libsss-nss-idmap0 (2.2.3-3) ... Setting up libsasl2-modules-gssapi-mit:amd64 (2.1.27+dfsg-2) ... Setting up libc++1-10:amd64 (1:10.0.0-4ubuntu1) ... Setting up python2.7 (2.7.18~rc1-2) ... Setting up libpython2-stdlib:amd64 (2.7.17-2ubuntu4) ... Setting up python2 (2.7.17-2ubuntu4) ... Setting up gdb (9.1-0ubuntu1) ... Setting up python-is-python2 (2.7.17-4) ... Setting up libc++1:amd64 (1:10.0-50~exp1) ... Setting up mssql-server (15.0.4033.1-2) ... debconf: unable to initialize frontend: Dialog debconf: (Dialog frontend requires a screen at least 13 lines tall and 31 columns wide.) debconf: falling back to frontend: Readline debconf: unable to initialize frontend: Readline debconf: (Can't locate Term/ReadLine.pm in @INC (you may need to install the Term::ReadLine module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /usr/share/perl5/Debconf/FrontEnd/Readline.pm line 7.) debconf: falling back to frontend: Teletype +--------------------------------------------------------------+ Please run 'sudo /opt/mssql/bin/mssql-conf setup' to complete the setup of Microsoft SQL Server +--------------------------------------------------------------+ Processing triggers for man-db (2.9.1-1) ... Processing triggers for mime-support (3.64ubuntu1) ... Processing triggers for libc-bin (2.31-0ubuntu9) ...
第 5 步:在 Ubuntu 20.04/18.04/16.04 上初始化 MS SQL Server 2019
$ sudo /opt/mssql/bin/mssql-conf setup 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) 7) Enterprise Core (PAID) 8) I bought a license through a retail sales channel and have a product key to enter.
Details about editions can be found at https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409
Use of PAID editions of this software requires separate licensing through a Microsoft Volume Licensing program. By choosing a PAID edition, you are verifying that you have the appropriate number of licenses in place to install and run this software.
Enter your edition(1-8): 2 The license terms for this product can be found in /usr/share/doc/mssql-server or downloaded from: https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409
The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409
Do you accept the license terms? [Yes/No]:Yes
Enter the SQL Server system administrator password: <SetStrongNewPassword> Confirm the SQL Server system administrator password: <ConfirmStrongPassword> Configuring SQL Server...
ForceFlush is enabled for this instance. ForceFlush feature is enabled forlog durability. Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /lib/systemd/system/mssql-server.service. Setup has completed successfully. SQL Server is now starting.
1> select name from sys.databases; 2> go name -------------------------------------------------------------------------------------------------------------------------------- master tempdb model msdb testDB
(5 rows affected)
外挂标签:
{% note [class] [no-icon] [style] %}
class 包括【default / primary / success / info / warning / danger】
style 包括【simple/modern/flat/disabled】
{% note success simple %}
{% endnote %}
图库:
<div class="gallery-group-main">
{% galleryGroup name description link img-url %}
{% galleryGroup name description link img-url %}
{% galleryGroup name description link img-url %}
</div>
name:圖庫名字
description:圖庫描述
link:連接到對應相冊的地址
img-url:圖庫封面的地址
如:{% galleryGroup '壁紙' '收藏的一些壁紙' '/Gallery/wallpaper' https://i.loli.net/2019/11/10/T7Mu8Aod3egmC4Q.png %}
Tabs:
{% tabs test1 %}
**This is Tab 1.**
**This is Tab 2.**
**This is Tab 3.**
{% endtabs %}
按钮:
{% btn 'https://butterfly.js.org/',Butterfly,far fa-hand-point-right,purple larger %}
颜色:default/blue/pink/red/purple/orange/green