Linux Mint 18.x上安装mysql8.0
前不久MySQL官方发布了 8.0版本,MySQL 8.0添加了很多不错的新特性,很值得以玩,这里讲解一下在Linux Mint 18.x上以apt方式安装MySQL。
Linux Mint 18.x兼容Ubuntu 16.04 LTS,所以该文章也适用于兼容Ubuntu 16.04 LTS版本的Linux 发行套件。
Add sources
MySQL官方将MySQL软件源APT Repository配置制作成了mysql-apt-config_x.y-z_all.deb,所以我们这里下载并安装mysql-apt-config_0.8.10-1_all.deb以便添加软件源。
lwk@qwfys ~/Downloads/Chromium $ wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
--2018-06-04 23:12:13-- https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://repo.mysql.com//mysql-apt-config_0.8.10-1_all.deb [following]
--2018-06-04 23:12:22-- https://repo.mysql.com//mysql-apt-config_0.8.10-1_all.deb
Resolving repo.mysql.com (repo.mysql.com)... 23.219.134.205
Connecting to repo.mysql.com (repo.mysql.com)|23.219.134.205|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 35970 (35K) [application/x-debian-package]
Saving to: ‘mysql-apt-config_0.8.10-1_all.deb’
mysql-apt-config_0.8.10-1_all.deb 100%[=========================================================================================================================================>] 35.13K --.-KB/s in 0.06s
2018-06-04 23:12:22 (628 KB/s) - ‘mysql-apt-config_0.8.10-1_all.deb’ saved [35970/35970]
这里用dpkg -i命令安装该.deb软件包:
lwk@qwfys ~/Downloads/Chromium $ sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb
(Reading database ... 301807 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.10-1_all.deb ...
Unpacking mysql-apt-config (0.8.10-1) over (0.8.10-1) ...
Setting up mysql-apt-config (0.8.10-1) ...
OK
lwk@qwfys ~/Downloads/Chromium $
添加软件源的过程中,会弹出如下对话框,选择”OK”,即可。
至此,软件源配置已经完成,这时会在目录/etc/apt/sources.list.d/中生成文件mysql.list:
lwk@qwfys ~ $ ll /etc/apt/sources.list.d/
total 28
drwxr-xr-x 2 root root 4096 Jun 4 23:28 ./
drwxr-xr-x 6 root root 4096 Jun 4 22:13 ../
-rw-r--r-- 1 root root 500 Jun 4 23:28 mysql.list
-rw-r--r-- 1 root root 489 May 15 23:15 official-package-repositories.list
-rw-r--r-- 1 root root 62 May 15 04:12 pgdg.list
-rw-r--r-- 1 root root 65 Jun 2 22:41 sogoupinyin.list
-rw-r--r-- 1 root root 81 May 15 04:07 virtualbox.list
lwk@qwfys ~ $ cat /etc/apt/sources.list.d/mysql.list
### THIS FILE IS AUTOMATICALLY CONFIGURED ###
# You may comment out entries below, but any other modifications may be lost.
# Use command 'dpkg-reconfigure mysql-apt-config' as root for modifications.
deb http://repo.mysql.com/apt/ubuntu/ xenial mysql-apt-config
deb http://repo.mysql.com/apt/ubuntu/ xenial mysql-8.0
deb http://repo.mysql.com/apt/ubuntu/ xenial mysql-tools
#deb http://repo.mysql.com/apt/ubuntu/ xenial mysql-tools-preview
deb-src http://repo.mysql.com/apt/ubuntu/ xenial mysql-8.0
lwk@qwfys ~ $
Update
更新本地apt软件包缓存以便 进一步安装:
lwk@qwfys ~ $ apt update
Ign:1 http://mirrors.ustc.edu.cn/linuxmint sylvia InRelease
Hit:2 http://archive.ubuntukylin.com:10006/ubuntukylin xenial InRelease
Hit:3 http://mirrors.ustc.edu.cn/ubuntu xenial InRelease
Hit:4 http://mirrors.ustc.edu.cn/ubuntu xenial-updates InRelease
Hit:5 http://repo.mysql.com/apt/ubuntu xenial InRelease
Hit:6 http://mirrors.ustc.edu.cn/ubuntu xenial-backports InRelease
Hit:7 http://download.virtualbox.org/virtualbox/debian xenial InRelease
Hit:8 http://mirrors.ustc.edu.cn/linuxmint sylvia Release
Hit:9 http://archive.canonical.com/ubuntu xenial InRelease
Hit:11 http://apt.postgresql.org/pub/repos/apt xenial-pgdg InRelease
Hit:12 http://security.ubuntu.com/ubuntu xenial-security InRelease
Reading package lists... Done
Building dependency tree
Reading state information... Done
All packages are up to date.
lwk@qwfys ~ $
Install
安装前先用如下命令查询待安装的软件包的版本是否存在:
lwk@qwfys ~ $ apt list |grep mysql
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
akonadi-backend-mysql/xenial,xenial 4:15.12.3-0ubuntu6 all
aolserver4-nsmysql/xenial 0.6-10build1 amd64
asterisk-mysql/xenial-updates 1:13.1.0~dfsg-1.1ubuntu4.1 amd64
automysqlbackup/xenial,xenial 2.6+debian.4-1 all
bacula-common-mysql/xenial-updates 7.0.5+dfsg-4ubuntu0.1 amd64
bacula-common-mysql-dbg/xenial-updates 7.0.5+dfsg-4ubuntu0.1 amd64
bacula-director-mysql/xenial-updates 7.0.5+dfsg-4ubuntu0.1 amd64
bacula-director-mysql-dbg/xenial-updates 7.0.5+dfsg-4ubuntu0.1 amd64
bacula-sd-mysql/xenial-updates 7.0.5+dfsg-4ubuntu0.1 amd64
bacula-sd-mysql-dbg/xenial-updates 7.0.5+dfsg-4ubuntu0.1 amd64
bareos-database-mysql/xenial 14.2.6-3 amd64
cl-sql-mysql/xenial 6.7.0-1build1 amd64
conquest-mysql/xenial 1.4.17d-1build1 amd64
courier-authlib-mysql/xenial 0.66.4-3build1 amd64
cvm-mysql/xenial 0.96-1.2build1 amd64
dbconfig-mysql/xenial,xenial 2.0.4ubuntu1 all
dbf2mysql/xenial 1.14a-4build1 amd64
diaspora-installer-mysql/xenial,xenial 0.5.7.1+debian2 all
dovecot-mysql/xenial-updates,xenial-security 1:2.2.22-1ubuntu2.7 amd64
dpm-copy-server-mysql/xenial 1.8.10-1build3 amd64
dpm-name-server-mysql/xenial 1.8.10-1build3 amd64
dpm-server-mysql/xenial 1.8.10-1build3 amd64
dpm-srm-server-mysql/xenial 1.8.10-1build3 amd64
dpsyco-mysql/xenial,xenial 1.0.36 all
dsyslog-module-mysql/xenial 0.6.0+nmu2ubuntu2 amd64
erlang-p1-mysql/xenial 1.0.0-1 amd64
freeradius-mysql/xenial-updates,xenial-security 2.2.8+dfsg-0.1ubuntu0.1 amd64
gambas3-gb-db-mysql/xenial-updates 3.8.4-2ubuntu3.1 amd64
gambas3-gb-mysql/xenial-updates 3.8.4-2ubuntu3.1 amd64
gmysqlcc/xenial 0.3.0-5build1 amd64
gnash-ext-mysql/xenial 0.8.11~git20160109-1build1 amd64
gnokii-smsd-mysql/xenial 0.6.31+dfsg-2ubuntu3 amd64
golang-github-go-sql-driver-mysql-dev/xenial,xenial 1.2-1 all
groonga-normalizer-mysql/xenial 1.1.0-1 amd64
icinga2-ido-mysql/xenial 2.4.1-2ubuntu1 amd64
kamailio-mysql-modules/xenial 4.3.4-1.1ubuntu2 amd64
kexi-mysql-driver/xenial 1:2.9.7-0ubuntu12 amd64
lfc-server-mysql/xenial 1.8.10-1build3 amd64
libapache2-mod-log-sql-mysql/xenial 1.100-16.2build1 amd64
libaprutil1-dbd-mysql/xenial 1.5.4-1build1 amd64
libclass-dbi-mysql-perl/xenial,xenial 1.00-3 all
libcppdb-mysql0/xenial 0.3.1+dfsg-3build1 amd64
libcrypt-mysql-perl/xenial 0.04-6build1 amd64
libdatetime-format-mysql-perl/xenial,xenial 0.05-2 all
libdbd-mysql/xenial 0.9.0-3ubuntu2 amd64
libdbd-mysql-perl/xenial-updates,xenial-security 4.033-1ubuntu0.1 amd64
libgda-5.0-mysql/xenial 5.2.4-1ubuntu1 amd64
libmysql++-dev/xenial 3.2.2+pristine-1ubuntu1 amd64
libmysql++-doc/xenial,xenial 3.2.2+pristine-1ubuntu1 all
libmysql++3v5/xenial 3.2.2+pristine-1ubuntu1 amd64
libmysql-cil-dev/xenial,xenial 6.4.3-4 all
libmysql-diff-perl/xenial,xenial 0.43-3 all
libmysql-java/xenial,xenial 5.1.38-1 all
libmysql-ocaml/xenial 1.2.0-2build2 amd64
libmysql-ocaml-dev/xenial 1.2.0-2build2 amd64
libmysql6.4-cil/xenial,xenial 6.4.3-4 all
libmysqlclient-dev/unknown 8.0.11-1ubuntu16.04 amd64
libmysqlclient20/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
libmysqlclient21/unknown 8.0.11-1ubuntu16.04 amd64
libmysqlclient21-dbgsym/unknown 8.0.11-1ubuntu16.04 amd64
libmysqlcppconn-dev/xenial 1.1.7-0ubuntu1 amd64
libmysqlcppconn7v5/xenial 1.1.7-0ubuntu1 amd64
libmysqld-dev/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
libnss-mysql-bg/xenial 1.5-4build1 amd64
libodb-mysql-2.4/xenial 2.4.0-1ubuntu1 amd64
libodb-mysql-dev/xenial 2.4.0-1ubuntu1 amd64
libopendbx1-mysql/xenial 1.4.6-9build1 amd64
libpam-mysql/xenial 0.7~RC1-4ubuntu2 amd64
libpocomysql9v5/xenial 1.3.6p1-5.1build1 amd64
libpocomysql9v5-dbg/xenial 1.3.6p1-5.1build1 amd64
libqt4-sql-mysql/xenial 4:4.8.7+dfsg-5ubuntu2 amd64
libqt5sql5-mysql/xenial-updates 5.5.1+dfsg-16ubuntu7.5 amd64
librdf-storage-mysql/xenial 1.0.17-1build1 amd64
libreoffice-mysql-connector/xenial-updates,xenial-security 1.0.2+LibO5.1.6~rc2-0ubuntu1~xenial3 amd64
libsoci-mysql3.2v5/xenial 3.2.3-1ubuntu2 amd64
libtime-piece-mysql-perl/xenial,xenial 0.06-2 all
libwtdbomysql-dev/xenial 3.3.4+dfsg-6ubuntu1 amd64
libwtdbomysql38/xenial 3.3.4+dfsg-6ubuntu1 amd64
lighttpd-mod-mysql-vhost/xenial 1.4.35-4ubuntu2 amd64
lua-dbi-mysql/xenial 0.5.hg5ba1dd988961-3build1 amd64
lua-dbi-mysql-dbg/xenial 0.5.hg5ba1dd988961-3build1 amd64
lua-dbi-mysql-dev/xenial 0.5.hg5ba1dd988961-3build1 amd64
lua-sql-mysql/xenial 2.3.0-4build1 amd64
lua-sql-mysql-dev/xenial 2.3.0-4build1 amd64
mha4mysql-manager/xenial,xenial 0.55-1 all
mha4mysql-node/xenial,xenial 0.54-1 all
monodoc-mysql-manual/xenial,xenial 6.4.3-4 all
mysql-apt-config/unknown,unknown,now 0.8.10-1 all [installed]
mysql-client/unknown 8.0.11-1ubuntu16.04 amd64
mysql-client-5.7/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
mysql-client-core-5.7/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
mysql-common/unknown,now 8.0.11-1ubuntu16.04 amd64 [residual-config]
mysql-community-client/unknown,now 8.0.11-1ubuntu16.04 amd64 [residual-config]
mysql-community-client-core/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-client-core-dbgsym/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-client-dbgsym/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-server/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-server-core/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-server-core-dbgsym/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-server-dbgsym/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-source/unknown 8.0.2-dmr-1ubuntu16.04 amd64
mysql-community-test/unknown 8.0.11-1ubuntu16.04 amd64
mysql-community-test-dbgsym/unknown 8.0.11-1ubuntu16.04 amd64
mysql-connector-java/unknown,unknown 8.0.11-1ubuntu16.04 all
mysql-connector-python/unknown,unknown 8.0.11-1ubuntu16.04 all
mysql-connector-python-cext/unknown 8.0.11-1ubuntu16.04 amd64
mysql-connector-python-cext-py3/unknown 8.0.11-1ubuntu16.04 amd64
mysql-connector-python-py3/unknown,unknown 8.0.11-1ubuntu16.04 all
mysql-mmm-agent/xenial,xenial 2.2.1-1.1 all
mysql-mmm-common/xenial,xenial 2.2.1-1.1 all
mysql-mmm-monitor/xenial,xenial 2.2.1-1.1 all
mysql-mmm-tools/xenial,xenial 2.2.1-1.1 all
mysql-router/unknown 8.0.11-1ubuntu16.04 amd64
mysql-router-dev/unknown 8.0.11-1ubuntu16.04 amd64
mysql-sandbox/xenial,xenial 3.1.04-1 all
mysql-server/unknown 8.0.11-1ubuntu16.04 amd64
mysql-server-5.7/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
mysql-server-core-5.7/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
mysql-shell/unknown 8.0.11-1ubuntu16.04 amd64
mysql-source-5.7/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
mysql-testsuite/unknown 8.0.11-1ubuntu16.04 amd64
mysql-testsuite-5.7/xenial-updates,xenial-security 5.7.22-0ubuntu0.16.04.1 amd64
mysql-utilities/unknown,unknown 1.6.5-1ubuntu16.04 all
mysql-workbench/xenial 6.3.6+dfsg-0ubuntu1 amd64
mysql-workbench-community/unknown 6.3.10-1ubuntu16.04 amd64
mysql-workbench-data/xenial,xenial 6.3.6+dfsg-0ubuntu1 all
mysqltcl/xenial 3.052-1build1 amd64
mysqltuner/xenial,xenial 1.6.0-1 all
ndoutils-nagios3-mysql/xenial 1.4b9-1.1build2 amd64
node-mysql/xenial,xenial 2.4.2-1 all
nuauth-log-mysql/xenial 2.4.3-3.3build2 amd64
oar-server-mysql/xenial 2.5.6-2ubuntu1 amd64
oar-user-mysql/xenial 2.5.6-2ubuntu1 amd64
opendnssec-enforcer-mysql/xenial 1:1.4.9-2 amd64
parser3-mysql/xenial 10.6-3build1 amd64
pdns-backend-mysql/xenial 4.0.0~alpha2-3build1 amd64
perdition-mysql/xenial 2.1-2build1 amd64
php-mdb2-driver-mysql/xenial,xenial 1.5.0b4-1ubuntu1 all
php-mysql/xenial-updates,xenial-updates 1:7.0+35ubuntu6.1 all
php7.0-mysql/xenial-updates,xenial-security 7.0.30-0ubuntu0.16.04.1 amd64
pike7.8-mysql/xenial 7.8.866-5build1 amd64
pike8.0-mysql/xenial 8.0.164-1build1 amd64
pinba-engine-mysql/xenial-updates,xenial-updates,xenial-security,xenial-security 1.1.0-1ubuntu1.8 all
pinba-engine-mysql-5.7/xenial-updates,xenial-security 1.1.0-1ubuntu1.8 amd64
postfix-cluebringer-mysql/xenial,xenial 2.0.10-1ubuntu1 all
postfix-mysql/xenial-updates 3.1.0-3ubuntu0.3 amd64
postgresql-10-mysql-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.3-mysql-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.4-mysql-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.5-mysql-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.6-mysql-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-mysql-fdw-doc/xenial-pgdg,xenial-pgdg 2.2.0-2.pgdg16.04+1 all
proftpd-mod-mysql/xenial 1.3.5a-1build1 amd64
puppet-module-puppetlabs-mysql/xenial,xenial 3.6.1-1 all
pure-ftpd-mysql/xenial 1.0.36-3.2build1 amd64
python-mysql.connector/xenial,xenial 2.0.4-1 all
python-mysqldb/xenial 1.3.7-1build2 amd64
python-mysqldb-dbg/xenial 1.3.7-1build2 amd64
python-pymysql/xenial-updates,xenial-updates 0.7.2-1ubuntu1 all
python3-mysql.connector/xenial,xenial 2.0.4-1 all
python3-mysqldb/xenial 1.3.7-1build2 amd64
python3-mysqldb-dbg/xenial 1.3.7-1build2 amd64
python3-pymysql/xenial-updates,xenial-updates 0.7.2-1ubuntu1 all
r-cran-rmysql/xenial 0.10.8-1 amd64
redmine-mysql/xenial,xenial 3.2.1-2 all
root-plugin-sql-mysql/xenial 5.34.30-0ubuntu8 amd64
roundcube-mysql/xenial,xenial 1.2~beta+dfsg.1-0ubuntu1 all
rsyslog-mysql/xenial 8.16.0-1ubuntu3 amd64
rt4-db-mysql/xenial,xenial 4.2.12-5 all
ruby-dataobjects-mysql/xenial 0.10.16-1ubuntu1 amd64
ruby-mysql/xenial 2.9.1-1ubuntu1 amd64
ruby-mysql2/xenial 0.4.3-2ubuntu2 amd64
strongswan-plugin-mysql/xenial-updates,xenial-updates 5.3.5-1ubuntu3.5 all
tarantool-lts-mysql-module/xenial 1.5.5-18-g2998d20-1ubuntu1 amd64
tcl8.6-tdbc-mysql/xenial 1.0.3-1ubuntu1 amd64
tntdb-mysql4v5/xenial 1.3-3build1 amd64
ulogd-mysql/xenial 2.0.5-2build1 amd64
ulogd2-mysql/xenial 2.0.5-2build1 amd64
voms-mysql-plugin/xenial 3.1.6-1build1 amd64
voms-mysql-plugin-dbg/xenial 3.1.6-1build1 amd64
yate-mysql/xenial 5.4.0-1-1ubuntu2 amd64
zabbix-proxy-mysql/xenial-updates 1:2.4.7+dfsg-2ubuntu2.1 amd64
zabbix-server-mysql/xenial-updates 1:2.4.7+dfsg-2ubuntu2.1 amd64
lwk@qwfys ~ $
可以看到只要安装mysql-server包就可以安装MySQL 8.0了,为了方便后续通过 GUI工具进行管理,这里可以安装mysql workbench。
lwk@qwfys ~ $ apt install mysql-client mysql-server mysql-workbench -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libaec0 libaio1 libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libkmlbase1 libkmldom1 libkmlengine1 libmecab2 libminizip1
libmysqlclient20 libmysqlcppconn7v5 libnetcdf11 libodbc1 libogdi3.2 libopenjp2-7 libpcrecpp0v5 libproj9 libspatialite7 libsuperlu4 libsz2 liburiparser1 libvsqlitepp3v5 libxerces-c3.1 mysql-common mysql-community-client
mysql-community-client-core mysql-community-server mysql-community-server-core mysql-workbench-data odbcinst odbcinst1debian2 proj-data python-mysql.connector python-pyodbc
Suggested packages:
libhdf4-doc libhdf4-alt-dev hdf4-tools libnetcdf4 libmyodbc odbc-postgresql tdsodbc unixodbc-bin ogdi-bin proj-bin
Recommended packages:
proj-bin mecab-ipadic-utf8 ttf-bitstream-vera mysql-utilities
The following NEW packages will be installed:
libaec0 libaio1 libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libkmlbase1 libkmldom1 libkmlengine1 libmecab2 libminizip1
libmysqlclient20 libmysqlcppconn7v5 libnetcdf11 libodbc1 libogdi3.2 libopenjp2-7 libpcrecpp0v5 libproj9 libspatialite7 libsuperlu4 libsz2 liburiparser1 libvsqlitepp3v5 libxerces-c3.1 mysql-client mysql-common mysql-community-client
mysql-community-client-core mysql-community-server mysql-community-server-core mysql-server mysql-workbench mysql-workbench-data odbcinst odbcinst1debian2 proj-data python-mysql.connector python-pyodbc
0 upgraded, 47 newly installed, 0 to remove and 0 not upgraded.
Need to get 25.1 MB/62.1 MB of archives.
After this operation, 506 MB of additional disk space will be used.
Get:1 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 libpcrecpp0v5 amd64 2:8.38-3.1 [15.2 kB]
Get:2 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libsuperlu4 amd64 4.3+dfsg-3 [158 kB]
Get:3 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libaec0 amd64 0.3.2-1 [18.0 kB]
Get:4 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libarpack2 amd64 3.3.0-1build2 [88.2 kB]
Get:5 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libarmadillo6 amd64 1:6.500.5+dfsg-1 [75.2 kB]
Get:6 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libctemplate2v5 amd64 2.2-5ubuntu1 [144 kB]
Get:7 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libdap17v5 amd64 3.15.1-7 [412 kB]
Get:8 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libdapclient6v5 amd64 3.15.1-7 [85.3 kB]
Get:9 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libepsilon1 amd64 0.9.2-3ubuntu1 [41.0 kB]
Get:10 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libfreexl1 amd64 1.0.2-1 [33.6 kB]
Get:11 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libgeos-3.5.0 amd64 3.5.0-1ubuntu2 [477 kB]
Get:12 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libgeos-c1v5 amd64 3.5.0-1ubuntu2 [52.4 kB]
Get:13 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libhdf4-0-alt amd64 4.2.10-3.2 [264 kB]
Get:14 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libsz2 amd64 0.3.2-1 [5,048 B]
Get:15 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libhdf5-10 amd64 1.8.16+docs-4ubuntu1 [995 kB]
Get:16 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libminizip1 amd64 1.1-8 [20.3 kB]
Get:17 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 liburiparser1 amd64 0.8.4-1 [38.0 kB]
Get:18 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libkmlbase1 amd64 1.3.0-1 [43.9 kB]
Get:19 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libkmldom1 amd64 1.3.0-1 [175 kB]
Get:20 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libkmlengine1 amd64 1.3.0-1 [77.1 kB]
Get:21 http://mirrors.ustc.edu.cn/ubuntu xenial-updates/main amd64 libmysqlclient20 amd64 5.7.22-0ubuntu0.16.04.1 [809 kB]
Get:22 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libnetcdf11 amd64 1:4.4.0-2 [286 kB]
Get:23 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 libodbc1 amd64 2.3.1-4.1 [180 kB]
Get:24 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 proj-data all 4.9.2-2 [4,004 kB]
Get:25 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libproj9 amd64 4.9.2-2 [143 kB]
Get:26 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libogdi3.2 amd64 3.2.0~beta2-7.1build1 [212 kB]
Get:27 http://mirrors.ustc.edu.cn/ubuntu xenial-updates/universe amd64 libopenjp2-7 amd64 2.1.0-2.1ubuntu0.1 [103 kB]
Get:28 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libspatialite7 amd64 4.3.0a-5 [1,222 kB]
Get:29 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libxerces-c3.1 amd64 3.1.3+debian-1 [842 kB]
Get:30 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 odbcinst amd64 2.3.1-4.1 [13.1 kB]
Get:31 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 odbcinst1debian2 amd64 2.3.1-4.1 [41.1 kB]
Get:32 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libgdal1i amd64 1.11.3+dfsg-3build2 [4,013 kB]
Get:33 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libmysqlcppconn7v5 amd64 1.1.7-0ubuntu1 [226 kB]
Get:34 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 libvsqlitepp3v5 amd64 0.3.13-3.1 [43.5 kB]
Get:35 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 mysql-workbench-data all 6.3.6+dfsg-0ubuntu1 [1,286 kB]
Get:36 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python-mysql.connector all 2.0.4-1 [86.9 kB]
Get:37 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python-pyodbc amd64 3.0.7-0ubuntu2 [44.4 kB]
Get:38 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 mysql-workbench amd64 6.3.6+dfsg-0ubuntu1 [8,287 kB]
Fetched 25.1 MB in 4s (5,427 kB/s)
Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting previously unselected package libpcrecpp0v5:amd64.
(Reading database ... 301570 files and directories currently installed.)
Preparing to unpack .../libpcrecpp0v5_2%3a8.38-3.1_amd64.deb ...
Unpacking libpcrecpp0v5:amd64 (2:8.38-3.1) ...
Selecting previously unselected package libsuperlu4:amd64.
Preparing to unpack .../libsuperlu4_4.3+dfsg-3_amd64.deb ...
Unpacking libsuperlu4:amd64 (4.3+dfsg-3) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-common (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package mysql-community-client-core.
Preparing to unpack .../mysql-community-client-core_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-community-client-core (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package mysql-community-client.
Preparing to unpack .../mysql-community-client_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-community-client (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package mysql-client.
Preparing to unpack .../mysql-client_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-client (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package libaio1:amd64.
Preparing to unpack .../libaio1_0.3.110-2_amd64.deb ...
Unpacking libaio1:amd64 (0.3.110-2) ...
Selecting previously unselected package libmecab2.
Preparing to unpack .../libmecab2_0.996-1.2ubuntu1_amd64.deb ...
Unpacking libmecab2 (0.996-1.2ubuntu1) ...
Selecting previously unselected package mysql-community-server-core.
Preparing to unpack .../mysql-community-server-core_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-community-server-core (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package mysql-community-server.
Preparing to unpack .../mysql-community-server_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-community-server (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package libaec0:amd64.
Preparing to unpack .../libaec0_0.3.2-1_amd64.deb ...
Unpacking libaec0:amd64 (0.3.2-1) ...
Selecting previously unselected package libarpack2.
Preparing to unpack .../libarpack2_3.3.0-1build2_amd64.deb ...
Unpacking libarpack2 (3.3.0-1build2) ...
Selecting previously unselected package libarmadillo6.
Preparing to unpack .../libarmadillo6_1%3a6.500.5+dfsg-1_amd64.deb ...
Unpacking libarmadillo6 (1:6.500.5+dfsg-1) ...
Selecting previously unselected package libctemplate2v5.
Preparing to unpack .../libctemplate2v5_2.2-5ubuntu1_amd64.deb ...
Unpacking libctemplate2v5 (2.2-5ubuntu1) ...
Selecting previously unselected package libdap17v5:amd64.
Preparing to unpack .../libdap17v5_3.15.1-7_amd64.deb ...
Unpacking libdap17v5:amd64 (3.15.1-7) ...
Selecting previously unselected package libdapclient6v5:amd64.
Preparing to unpack .../libdapclient6v5_3.15.1-7_amd64.deb ...
Unpacking libdapclient6v5:amd64 (3.15.1-7) ...
Selecting previously unselected package libepsilon1:amd64.
Preparing to unpack .../libepsilon1_0.9.2-3ubuntu1_amd64.deb ...
Unpacking libepsilon1:amd64 (0.9.2-3ubuntu1) ...
Selecting previously unselected package libfreexl1:amd64.
Preparing to unpack .../libfreexl1_1.0.2-1_amd64.deb ...
Unpacking libfreexl1:amd64 (1.0.2-1) ...
Selecting previously unselected package libgeos-3.5.0.
Preparing to unpack .../libgeos-3.5.0_3.5.0-1ubuntu2_amd64.deb ...
Unpacking libgeos-3.5.0 (3.5.0-1ubuntu2) ...
Selecting previously unselected package libgeos-c1v5.
Preparing to unpack .../libgeos-c1v5_3.5.0-1ubuntu2_amd64.deb ...
Unpacking libgeos-c1v5 (3.5.0-1ubuntu2) ...
Selecting previously unselected package libhdf4-0-alt.
Preparing to unpack .../libhdf4-0-alt_4.2.10-3.2_amd64.deb ...
Unpacking libhdf4-0-alt (4.2.10-3.2) ...
Selecting previously unselected package libsz2:amd64.
Preparing to unpack .../libsz2_0.3.2-1_amd64.deb ...
Unpacking libsz2:amd64 (0.3.2-1) ...
Selecting previously unselected package libhdf5-10:amd64.
Preparing to unpack .../libhdf5-10_1.8.16+docs-4ubuntu1_amd64.deb ...
Unpacking libhdf5-10:amd64 (1.8.16+docs-4ubuntu1) ...
Selecting previously unselected package libminizip1:amd64.
Preparing to unpack .../libminizip1_1.1-8_amd64.deb ...
Unpacking libminizip1:amd64 (1.1-8) ...
Selecting previously unselected package liburiparser1:amd64.
Preparing to unpack .../liburiparser1_0.8.4-1_amd64.deb ...
Unpacking liburiparser1:amd64 (0.8.4-1) ...
Selecting previously unselected package libkmlbase1:amd64.
Preparing to unpack .../libkmlbase1_1.3.0-1_amd64.deb ...
Unpacking libkmlbase1:amd64 (1.3.0-1) ...
Selecting previously unselected package libkmldom1:amd64.
Preparing to unpack .../libkmldom1_1.3.0-1_amd64.deb ...
Unpacking libkmldom1:amd64 (1.3.0-1) ...
Selecting previously unselected package libkmlengine1:amd64.
Preparing to unpack .../libkmlengine1_1.3.0-1_amd64.deb ...
Unpacking libkmlengine1:amd64 (1.3.0-1) ...
Selecting previously unselected package libmysqlclient20:amd64.
Preparing to unpack .../libmysqlclient20_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking libmysqlclient20:amd64 (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package libnetcdf11.
Preparing to unpack .../libnetcdf11_1%3a4.4.0-2_amd64.deb ...
Unpacking libnetcdf11 (1:4.4.0-2) ...
Selecting previously unselected package libodbc1:amd64.
Preparing to unpack .../libodbc1_2.3.1-4.1_amd64.deb ...
Unpacking libodbc1:amd64 (2.3.1-4.1) ...
Selecting previously unselected package proj-data.
Preparing to unpack .../proj-data_4.9.2-2_all.deb ...
Unpacking proj-data (4.9.2-2) ...
Selecting previously unselected package libproj9.
Preparing to unpack .../libproj9_4.9.2-2_amd64.deb ...
Unpacking libproj9 (4.9.2-2) ...
Selecting previously unselected package libogdi3.2.
Preparing to unpack .../libogdi3.2_3.2.0~beta2-7.1build1_amd64.deb ...
Unpacking libogdi3.2 (3.2.0~beta2-7.1build1) ...
Selecting previously unselected package libopenjp2-7:amd64.
Preparing to unpack .../libopenjp2-7_2.1.0-2.1ubuntu0.1_amd64.deb ...
Unpacking libopenjp2-7:amd64 (2.1.0-2.1ubuntu0.1) ...
Selecting previously unselected package libspatialite7:amd64.
Preparing to unpack .../libspatialite7_4.3.0a-5_amd64.deb ...
Unpacking libspatialite7:amd64 (4.3.0a-5) ...
Selecting previously unselected package libxerces-c3.1:amd64.
Preparing to unpack .../libxerces-c3.1_3.1.3+debian-1_amd64.deb ...
Unpacking libxerces-c3.1:amd64 (3.1.3+debian-1) ...
Selecting previously unselected package odbcinst.
Preparing to unpack .../odbcinst_2.3.1-4.1_amd64.deb ...
Unpacking odbcinst (2.3.1-4.1) ...
Selecting previously unselected package odbcinst1debian2:amd64.
Preparing to unpack .../odbcinst1debian2_2.3.1-4.1_amd64.deb ...
Unpacking odbcinst1debian2:amd64 (2.3.1-4.1) ...
Selecting previously unselected package libgdal1i.
Preparing to unpack .../libgdal1i_1.11.3+dfsg-3build2_amd64.deb ...
Unpacking libgdal1i (1.11.3+dfsg-3build2) ...
Selecting previously unselected package libmysqlcppconn7v5.
Preparing to unpack .../libmysqlcppconn7v5_1.1.7-0ubuntu1_amd64.deb ...
Unpacking libmysqlcppconn7v5 (1.1.7-0ubuntu1) ...
Selecting previously unselected package libvsqlitepp3v5:amd64.
Preparing to unpack .../libvsqlitepp3v5_0.3.13-3.1_amd64.deb ...
Unpacking libvsqlitepp3v5:amd64 (0.3.13-3.1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_8.0.11-1ubuntu16.04_amd64.deb ...
Unpacking mysql-server (8.0.11-1ubuntu16.04) ...
Selecting previously unselected package mysql-workbench-data.
Preparing to unpack .../mysql-workbench-data_6.3.6+dfsg-0ubuntu1_all.deb ...
Unpacking mysql-workbench-data (6.3.6+dfsg-0ubuntu1) ...
Selecting previously unselected package python-mysql.connector.
Preparing to unpack .../python-mysql.connector_2.0.4-1_all.deb ...
Unpacking python-mysql.connector (2.0.4-1) ...
Selecting previously unselected package python-pyodbc.
Preparing to unpack .../python-pyodbc_3.0.7-0ubuntu2_amd64.deb ...
Unpacking python-pyodbc (3.0.7-0ubuntu2) ...
Selecting previously unselected package mysql-workbench.
Preparing to unpack .../mysql-workbench_6.3.6+dfsg-0ubuntu1_amd64.deb ...
Unpacking mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for systemd (229-4ubuntu21.2) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
Processing triggers for mime-support (3.59ubuntu1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ...
Processing triggers for desktop-file-utils (0.22+linuxmint1) ...
Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
Setting up libpcrecpp0v5:amd64 (2:8.38-3.1) ...
Setting up libsuperlu4:amd64 (4.3+dfsg-3) ...
Setting up mysql-common (8.0.11-1ubuntu16.04) ...
Setting up mysql-community-client-core (8.0.11-1ubuntu16.04) ...
Setting up mysql-community-client (8.0.11-1ubuntu16.04) ...
Setting up mysql-client (8.0.11-1ubuntu16.04) ...
Setting up libaio1:amd64 (0.3.110-2) ...
Setting up libmecab2 (0.996-1.2ubuntu1) ...
Setting up mysql-community-server-core (8.0.11-1ubuntu16.04) ...
Setting up mysql-community-server (8.0.11-1ubuntu16.04) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up libaec0:amd64 (0.3.2-1) ...
Setting up libarpack2 (3.3.0-1build2) ...
Setting up libarmadillo6 (1:6.500.5+dfsg-1) ...
Setting up libctemplate2v5 (2.2-5ubuntu1) ...
Setting up libdap17v5:amd64 (3.15.1-7) ...
Setting up libdapclient6v5:amd64 (3.15.1-7) ...
Setting up libepsilon1:amd64 (0.9.2-3ubuntu1) ...
Setting up libfreexl1:amd64 (1.0.2-1) ...
Setting up libgeos-3.5.0 (3.5.0-1ubuntu2) ...
Setting up libgeos-c1v5 (3.5.0-1ubuntu2) ...
Setting up libhdf4-0-alt (4.2.10-3.2) ...
Setting up libsz2:amd64 (0.3.2-1) ...
Setting up libhdf5-10:amd64 (1.8.16+docs-4ubuntu1) ...
Setting up libminizip1:amd64 (1.1-8) ...
Setting up liburiparser1:amd64 (0.8.4-1) ...
Setting up libkmlbase1:amd64 (1.3.0-1) ...
Setting up libkmldom1:amd64 (1.3.0-1) ...
Setting up libkmlengine1:amd64 (1.3.0-1) ...
Setting up libmysqlclient20:amd64 (5.7.22-0ubuntu0.16.04.1) ...
Setting up libnetcdf11 (1:4.4.0-2) ...
Setting up libodbc1:amd64 (2.3.1-4.1) ...
Setting up proj-data (4.9.2-2) ...
Setting up libproj9 (4.9.2-2) ...
Setting up libogdi3.2 (3.2.0~beta2-7.1build1) ...
Setting up libopenjp2-7:amd64 (2.1.0-2.1ubuntu0.1) ...
Setting up libspatialite7:amd64 (4.3.0a-5) ...
Setting up libxerces-c3.1:amd64 (3.1.3+debian-1) ...
Setting up libmysqlcppconn7v5 (1.1.7-0ubuntu1) ...
Setting up libvsqlitepp3v5:amd64 (0.3.13-3.1) ...
Setting up mysql-server (8.0.11-1ubuntu16.04) ...
Setting up mysql-workbench-data (6.3.6+dfsg-0ubuntu1) ...
Setting up python-mysql.connector (2.0.4-1) ...
Setting up python-pyodbc (3.0.7-0ubuntu2) ...
Setting up odbcinst1debian2:amd64 (2.3.1-4.1) ...
Setting up libgdal1i (1.11.3+dfsg-3build2) ...
Setting up mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Setting up odbcinst (2.3.1-4.1) ...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for systemd (229-4ubuntu21.2) ...
Processing triggers for ureadahead (0.100.0-19) ...
lwk@qwfys ~ $
至此安装完成,执行如下命令可以查看MySQL服务运行状态:
lwk@qwfys ~ $ systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2018-06-04 23:38:58 CST; 3min 53s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Main PID: 15567 (mysqld)
Status: "SERVER_OPERATING"
CGroup: /system.slice/mysql.service
└─15567 /usr/sbin/mysqld
Jun 04 23:38:58 qwfys systemd[1]: Starting MySQL Community Server...
Jun 04 23:38:58 qwfys mysql-systemd-start[15529]: /usr/share/mysql-8.0/mysql-systemd-start: line 39: /lib/apparmor/profile-load: No such file or directory
Jun 04 23:38:58 qwfys systemd[1]: Started MySQL Community Server.
lwk@qwfys ~ $
我们看到,MySQL8.0 服务已经启动,运行状态良好。
在安装过程中,会依次出现输入密码、确认密码、账户安装模式选择三个对话框,如下所示。
初始密码
确认密码
账户安全模式
Connect to the Server
MSQL客户端很多,为了方便起见,这里我们使用命令行客户端工具,示例如下:
lwk@qwfys ~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.11 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> \h
For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
https://shop.mysql.com/
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
resetconnection(\x) Clean session context.
For server side help, type 'help contents'
mysql>
Create database
lwk@qwfys ~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.11 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database qwfys;
Query OK, 1 row affected (0.11 sec)
Grant user for Database
mysql> create user lwk identified by '123456';
Query OK, 0 rows affected (0.06 sec)
mysql> grant all on qwfys.* to lwk;
Query OK, 0 rows affected (0.18 sec)
mysql>
Uninstall
lwk@qwfys ~ $ apt purge mysql-client mysql-server mysql-workbench -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
libaec0 libaio1 libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libkmlbase1 libkmldom1 libkmlengine1 libmecab2 libminizip1
libmysqlclient20 libmysqlcppconn7v5 libnetcdf11 libodbc1 libogdi3.2 libopenjp2-7 libpcrecpp0v5 libproj9 libspatialite7 libsuperlu4 libsz2 liburiparser1 libvsqlitepp3v5 libxerces-c3.1 mysql-common mysql-community-client
mysql-community-client-core mysql-community-server-core mysql-workbench-data odbcinst odbcinst1debian2 proj-data python-mysql.connector python-pyodbc
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
mysql-client* mysql-community-server* mysql-server* mysql-workbench*
0 upgraded, 0 newly installed, 4 to remove and 0 not upgraded.
After this operation, 227 MB disk space will be freed.
(Reading database ... 303464 files and directories currently installed.)
Removing mysql-server (8.0.11-1ubuntu16.04) ...
Removing mysql-community-server (8.0.11-1ubuntu16.04) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Purging configuration files for mysql-community-server (8.0.11-1ubuntu16.04) ...
.
Removing mysql-client (8.0.11-1ubuntu16.04) ...
Removing mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Purging configuration files for mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ...
Processing triggers for desktop-file-utils (0.22+linuxmint1) ...
Processing triggers for mime-support (3.59ubuntu1) ...
lwk@qwfys ~ $ apt autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
libaec0 libaio1 libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libkmlbase1 libkmldom1 libkmlengine1 libmecab2 libminizip1
libmysqlclient20 libmysqlcppconn7v5 libnetcdf11 libodbc1 libogdi3.2 libopenjp2-7 libpcrecpp0v5 libproj9 libspatialite7 libsuperlu4 libsz2 liburiparser1 libvsqlitepp3v5 libxerces-c3.1 mysql-common mysql-community-client
mysql-community-client-core mysql-community-server-core mysql-workbench-data odbcinst odbcinst1debian2 proj-data python-mysql.connector python-pyodbc
0 upgraded, 0 newly installed, 43 to remove and 0 not upgraded.
After this operation, 279 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 303230 files and directories currently installed.)
Removing libgdal1i (1.11.3+dfsg-3build2) ...
Removing libnetcdf11 (1:4.4.0-2) ...
Removing libhdf5-10:amd64 (1.8.16+docs-4ubuntu1) ...
Removing libsz2:amd64 (0.3.2-1) ...
Removing libaec0:amd64 (0.3.2-1) ...
Removing mysql-community-server-core (8.0.11-1ubuntu16.04) ...
Removing libaio1:amd64 (0.3.110-2) ...
Removing libarmadillo6 (1:6.500.5+dfsg-1) ...
Removing libarpack2 (3.3.0-1build2) ...
Removing libctemplate2v5 (2.2-5ubuntu1) ...
Removing libdapclient6v5:amd64 (3.15.1-7) ...
Removing libdap17v5:amd64 (3.15.1-7) ...
Removing libepsilon1:amd64 (0.9.2-3ubuntu1) ...
Removing libspatialite7:amd64 (4.3.0a-5) ...
Removing libfreexl1:amd64 (1.0.2-1) ...
Removing libgeos-c1v5 (3.5.0-1ubuntu2) ...
Removing libgeos-3.5.0 (3.5.0-1ubuntu2) ...
Removing libhdf4-0-alt (4.2.10-3.2) ...
Removing libkmlengine1:amd64 (1.3.0-1) ...
Removing libkmldom1:amd64 (1.3.0-1) ...
Removing libkmlbase1:amd64 (1.3.0-1) ...
Removing libmecab2 (0.996-1.2ubuntu1) ...
Removing libminizip1:amd64 (1.1-8) ...
Removing libmysqlcppconn7v5 (1.1.7-0ubuntu1) ...
Removing libmysqlclient20:amd64 (5.7.22-0ubuntu0.16.04.1) ...
Removing python-pyodbc (3.0.7-0ubuntu2) ...
Removing libodbc1:amd64 (2.3.1-4.1) ...
Removing libogdi3.2 (3.2.0~beta2-7.1build1) ...
Removing libopenjp2-7:amd64 (2.1.0-2.1ubuntu0.1) ...
Removing libpcrecpp0v5:amd64 (2:8.38-3.1) ...
Removing libproj9 (4.9.2-2) ...
Removing libsuperlu4:amd64 (4.3+dfsg-3) ...
Removing liburiparser1:amd64 (0.8.4-1) ...
Removing libvsqlitepp3v5:amd64 (0.3.13-3.1) ...
Removing libxerces-c3.1:amd64 (3.1.3+debian-1) ...
Removing mysql-community-client (8.0.11-1ubuntu16.04) ...
Removing mysql-common (8.0.11-1ubuntu16.04) ...
Removing mysql-community-client-core (8.0.11-1ubuntu16.04) ...
Removing mysql-workbench-data (6.3.6+dfsg-0ubuntu1) ...
Removing proj-data (4.9.2-2) ...
Removing python-mysql.connector (2.0.4-1) ...
Removing odbcinst (2.3.1-4.1) ...
Removing odbcinst1debian2:amd64 (2.3.1-4.1) ...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
lwk@qwfys ~ $
浙公网安备 33010602011771号