install mysql 8.0 to Linux mint 19.0

install apt repository

download and install mysql-apt-config_0.8.10-1_all.deb

lwk@qwfys:~/Downloads$ ll
total 8
drwxr-xr-x  2 lwk lwk 4096 Aug  5 10:49 ./
drwxr-xr-x 31 lwk lwk 4096 Aug  5 10:43 ../
lwk@qwfys:~/Downloads$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
--2018-08-05 10:49:35--  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-08-05 10:49:41--  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.07s   

2018-08-05 10:49:42 (510 KB/s) - ‘mysql-apt-config_0.8.10-1_all.deb’ saved [35970/35970]

lwk@qwfys:~/Downloads$ ll
total 48
drwxr-xr-x  2 lwk lwk  4096 Aug  5 10:49 ./
drwxr-xr-x 31 lwk lwk  4096 Aug  5 10:43 ../
-rw-r--r--  1 lwk lwk 35970 Apr 18 14:26 mysql-apt-config_0.8.10-1_all.deb
lwk@qwfys:~/Downloads$ apt deb mysql-apt-config_0.8.10-1_all.deb 
[sudo] password for lwk: 
Selecting previously unselected package mysql-apt-config.
(Reading database ... 331884 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) ...
Setting up mysql-apt-config (0.8.10-1) ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
lwk@qwfys:~/Downloads$

Update local apt cache

lwk@qwfys:~/Downloads$ apt update
Get:1 http://repo.mysql.com/apt/ubuntu bionic InRelease [16.9 kB]
Ign:2 http://mirrors.ustc.edu.cn/linuxmint tara InRelease                                                                                                                                
Hit:3 http://mirrors.ustc.edu.cn/ubuntu bionic InRelease                                                                                                                           
Get:4 http://mirrors.ustc.edu.cn/ubuntu bionic-updates InRelease [88.7 kB]                                                                
Get:5 http://mirrors.ustc.edu.cn/ubuntu bionic-backports InRelease [74.6 kB]                                                                     
Hit:6 http://mirrors.ustc.edu.cn/linuxmint tara Release                                                                                          
Get:7 http://mirrors.ustc.edu.cn/ubuntu bionic-updates/main amd64 DEP-11 Metadata [138 kB]                                                 
Hit:8 http://archive.canonical.com/ubuntu bionic InRelease                                                                                              
Get:9 http://mirrors.ustc.edu.cn/ubuntu bionic-updates/universe amd64 DEP-11 Metadata [149 kB]                                                      
Get:10 http://security.ubuntu.com/ubuntu bionic-security InRelease [83.2 kB]                                                                                         
Get:11 http://mirrors.ustc.edu.cn/ubuntu bionic-updates/multiverse amd64 DEP-11 Metadata [2,464 B]                                                              
Get:12 http://mirrors.ustc.edu.cn/ubuntu bionic-backports/universe amd64 DEP-11 Metadata [5,100 B]                                                                              
Get:14 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 Sources [898 B]                                                                                                        
Hit:15 http://archive.ubuntukylin.com:10006/ubuntukylin xenial InRelease                 
Get:16 http://repo.mysql.com/apt/ubuntu bionic/mysql-apt-config amd64 Packages [568 B]
Get:17 http://repo.mysql.com/apt/ubuntu bionic/mysql-apt-config i386 Packages [568 B]
Get:18 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 Packages [7,002 B]
Get:19 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 i386 Packages [7,004 B]
Get:20 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools i386 Packages [1,882 B]
Get:21 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools amd64 Packages [2,519 B]                                                                                                                                                          
Fetched 579 kB in 7s (86.1 kB/s)                                                                                                                                                                                                             
Reading package lists... Done
Building dependency tree       
Reading state information... Done
All packages are up to date.
lwk@qwfys:~/Downloads$

Query the available MySQL installation package

lwk@qwfys:~/Downloads$ apt list |grep mysql

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

akonadi-backend-mysql/bionic,bionic 4:17.12.3-0ubuntu3 all
aolserver4-nsmysql/bionic 0.6-11 amd64
asterisk-mysql/bionic 1:13.18.3~dfsg-1ubuntu4 amd64
automysqlbackup/bionic,bionic 2.6+debian.4-1 all
bacula-common-mysql/bionic 9.0.6-1build1 amd64
bacula-director-mysql/bionic 9.0.6-1build1 amd64
cl-sql-mysql/bionic 6.7.0-1.1 amd64
courier-authlib-mysql/bionic 0.68.0-4build1 amd64
cvm-mysql/bionic 0.97-0.1 amd64
dbconfig-mysql/bionic,bionic 2.0.9 all
dbf2mysql/bionic 1.14a-5.1 amd64
default-libmysqlclient-dev/bionic 1.0.4 amd64
default-libmysqld-dev/bionic 1.0.4 amd64
default-mysql-client/bionic,bionic 1.0.4 all
default-mysql-client-core/bionic,bionic 1.0.4 all
default-mysql-server/bionic,bionic 1.0.4 all
default-mysql-server-core/bionic,bionic 1.0.4 all
diaspora-installer-mysql/bionic,bionic 0.7.3.1+debian2ubuntu2 all
dovecot-mysql/bionic-updates 1:2.2.33.2-1ubuntu4.1 amd64
dpm-copy-server-mysql/bionic 1.10.0-2 amd64
dpm-name-server-mysql/bionic 1.10.0-2 amd64
dpm-server-mysql/bionic 1.10.0-2 amd64
dpm-srm-server-mysql/bionic 1.10.0-2 amd64
erlang-p1-mysql/bionic 1.0.4-2 amd64
freeradius-mysql/bionic 3.0.16+dfsg-1ubuntu3 amd64
gmysqlcc/bionic 0.3.0-6 amd64
gnash-ext-mysql/bionic 0.8.11~git20160608-1.4 amd64
gnokii-smsd-mysql/bionic 0.6.31+dfsg-2ubuntu6 amd64
golang-github-go-sql-driver-mysql-dev/bionic,bionic 1.3-1 all
groonga-normalizer-mysql/bionic 1.1.1-4 amd64
homer-api-mysql/bionic 5.0.6+dfsg2-3 amd64
icinga2-ido-mysql/bionic 2.8.1-0ubuntu2 amd64
kamailio-mysql-modules/bionic 5.1.2-1ubuntu2 amd64
kexi-mysql-driver/bionic 1:3.1.0-2 amd64
lfc-server-mysql/bionic 1.10.0-2 amd64
libapache2-mod-log-sql-mysql/bionic 1.100-16.3 amd64
libaprutil1-dbd-mysql/bionic 1.6.1-2 amd64
libclass-dbi-mysql-perl/bionic,bionic 1.00-3 all
libcppdb-mysql0/bionic 0.3.1+dfsg-6 amd64
libcrypt-mysql-perl/bionic 0.04-6build3 amd64
libdatetime-format-mysql-perl/bionic,bionic 0.06-1 all
libdbd-mysql/bionic 0.9.0-5ubuntu2 amd64
libdbd-mysql-perl/bionic 4.046-1 amd64
libgda-5.0-mysql/bionic 5.2.4-9 amd64
libkdb3-driver-mysql/bionic 3.1.0-2 amd64
libmysql++-dev/bionic 3.2.2+pristine-2ubuntu3 amd64
libmysql++-doc/bionic,bionic 3.2.2+pristine-2ubuntu3 all
libmysql++3v5/bionic 3.2.2+pristine-2ubuntu3 amd64
libmysql-cil-dev/bionic,bionic 6.4.3-4 all
libmysql-diff-perl/bionic,bionic 0.50-1 all
libmysql-java/bionic,bionic 5.1.45-1 all
libmysql-ocaml/bionic 1.2.1-1build1 amd64
libmysql-ocaml-dev/bionic 1.2.1-1build1 amd64
libmysql6.4-cil/bionic,bionic 6.4.3-4 all
libmysqlclient-dev/unknown 8.0.12-1ubuntu18.04 amd64
libmysqlclient20/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
libmysqlclient21/unknown 8.0.12-1ubuntu18.04 amd64
libmysqlclient21-dbgsym/unknown 8.0.12-1ubuntu18.04 amd64
libmysqlcppconn-dev/bionic 1.1.9-1 amd64
libmysqlcppconn7v5/bionic 1.1.9-1 amd64
libmysqld-dev/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
libodb-mysql-2.4/bionic 2.4.0-3 amd64
libodb-mysql-dev/bionic 2.4.0-3 amd64
libopendbx1-mysql/bionic 1.4.6-11 amd64
libpam-mysql/bionic 0.8.0-1ubuntu2 amd64
libpocodatamysql50/bionic 1.8.0.1-1ubuntu4 amd64
libpreludedb7-mysql/bionic 4.1.0-1 amd64
libqt4-sql-mysql/bionic 4:4.8.7+dfsg-7ubuntu1 amd64
libqt5sql5-mysql/bionic 5.9.5+dfsg-0ubuntu1 amd64
librdf-storage-mysql/bionic 1.0.17-1.1 amd64
libreoffice-mysql-connector/bionic 1.0.2+LibO6.0.3-0ubuntu1 amd64
libsoci-mysql3.2v5/bionic 3.2.3-2ubuntu2 amd64
libtime-piece-mysql-perl/bionic,bionic 0.06-2 all
lighttpd-mod-authn-mysql/bionic 1.4.45-1ubuntu3 amd64
lighttpd-mod-mysql-vhost/bionic 1.4.45-1ubuntu3 amd64
lua-dbi-mysql/bionic 0.5.hg5ba1dd988961-4 amd64
lua-dbi-mysql-dbg/bionic 0.5.hg5ba1dd988961-4 amd64
lua-dbi-mysql-dev/bionic 0.5.hg5ba1dd988961-4 amd64
lua-sql-mysql/bionic 2.3.4-1 amd64
lua-sql-mysql-dev/bionic 2.3.4-1 amd64
mha4mysql-manager/bionic,bionic 0.55-1 all
mha4mysql-node/bionic,bionic 0.54-1 all
monodoc-mysql-manual/bionic,bionic 6.4.3-4 all
mysql-apt-config/unknown,unknown,now 0.8.10-1 all [installed]
mysql-client/unknown 8.0.12-1ubuntu18.04 amd64
mysql-client-5.7/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
mysql-client-core-5.7/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
mysql-common/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-client/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-client-core/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-client-core-dbgsym/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-client-dbgsym/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-server/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-server-core/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-server-core-dbgsym/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-server-dbgsym/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-test/unknown 8.0.12-1ubuntu18.04 amd64
mysql-community-test-dbgsym/unknown 8.0.12-1ubuntu18.04 amd64
mysql-connector-java/unknown,unknown 8.0.12-1ubuntu18.04 all
mysql-connector-python/unknown,unknown 8.0.12-1ubuntu18.04 all
mysql-connector-python-cext/unknown 8.0.12-1ubuntu18.04 amd64
mysql-connector-python-cext-py3/unknown 8.0.12-1ubuntu18.04 amd64
mysql-connector-python-py3/unknown,unknown 8.0.12-1ubuntu18.04 all
mysql-router/unknown 8.0.11-1ubuntu18.04 amd64
mysql-router-dev/unknown 8.0.11-1ubuntu18.04 amd64
mysql-sandbox/bionic,bionic 3.2.05-1 all
mysql-server/unknown 8.0.12-1ubuntu18.04 amd64
mysql-server-5.7/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
mysql-server-core-5.7/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
mysql-shell/unknown 8.0.12-1ubuntu18.04 amd64
mysql-source-5.7/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
mysql-testsuite/unknown 8.0.12-1ubuntu18.04 amd64
mysql-testsuite-5.7/bionic-updates,bionic-security 5.7.23-0ubuntu0.18.04.1 amd64
mysql-utilities/bionic,bionic 1.6.4-1 all
mysql-workbench/bionic 6.3.8+dfsg-1build3 amd64
mysql-workbench-community/unknown 8.0.12-1ubuntu18.04 amd64
mysql-workbench-data/bionic,bionic 6.3.8+dfsg-1build3 all
mysqltcl/bionic 3.052-2 amd64
mysqltuner/bionic,bionic 1.7.2-1 all
node-mysql/bionic,bionic 2.10.2-1 all
oar-server-mysql/bionic 2.5.7-3 amd64
oar-user-mysql/bionic 2.5.7-3 amd64
opendnssec-enforcer-mysql/bionic 1:2.1.3-0.2build1 amd64
opensips-mysql-module/bionic 2.2.2-3build4 amd64
parser3-mysql/bionic 10.7-2 amd64
pdns-backend-mysql/bionic 4.1.1-1 amd64
perdition-mysql/bionic 2.2-3ubuntu2 amd64
php-mdb2-driver-mysql/bionic,bionic 1.5.0b4-2 all
php-mysql/bionic,bionic 1:7.2+60ubuntu1 all
php7.2-mysql/bionic-updates,bionic-security 7.2.7-0ubuntu0.18.04.2 amd64
pike7.8-mysql/bionic 7.8.866-8.1 amd64
pike8.0-mysql/bionic 8.0.498-1build1 amd64
postfix-mysql/bionic 3.3.0-1 amd64
postgresql-10-mysql-fdw/bionic 2.3.0-2 amd64
proftpd-mod-mysql/bionic 1.3.5e-1build1 amd64
prometheus-mysqld-exporter/bionic 0.9.0+ds-3 amd64
puppet-module-puppetlabs-mysql/bionic,bionic 3.10.0-1 all
pure-ftpd-mysql/bionic 1.0.46-1build1 amd64
python-mysql.connector/bionic,bionic 2.1.6-1 all
python-mysqldb/bionic 1.3.10-1build1 amd64
python-mysqldb-dbg/bionic 1.3.10-1build1 amd64
python-pymysql/bionic,bionic 0.8.0-1 all
python-pymysql-doc/bionic,bionic 0.8.0-1 all
python-testing.mysqld/bionic,bionic 1.4.0-2 all
python3-mysql.connector/bionic,bionic 2.1.6-1 all
python3-mysqldb/bionic 1.3.10-1build1 amd64
python3-mysqldb-dbg/bionic 1.3.10-1build1 amd64
python3-pymysql/bionic,bionic 0.8.0-1 all
python3-testing.mysqld/bionic,bionic 1.4.0-2 all
r-cran-rmysql/bionic 0.10.13-2 amd64
redmine-mysql/bionic,bionic 3.4.4-1 all
roundcube-mysql/bionic,bionic 1.3.6+dfsg.1-1 all
rsyslog-mysql/bionic 8.32.0-1ubuntu4 amd64
rt4-db-mysql/bionic,bionic 4.4.2-2 all
ruby-dataobjects-mysql/bionic 0.10.16-2ubuntu3 amd64
ruby-mysql2/bionic 0.4.10-0ubuntu5 amd64
tarantool-lts-mysql-module/bionic 1.5.5.37.g1687c02-1 amd64
tcl8.6-tdbc-mysql/bionic 1.0.6-1 amd64
tntdb-mysql4v5/bionic 1.3-4 amd64
ulogd2-mysql/bionic 2.0.5-5 amd64
voms-mysql-plugin/bionic 3.1.7-2 amd64
w1retap-mysql/bionic 1.4.4-3 amd64
zabbix-proxy-mysql/bionic 1:3.0.12+dfsg-1 amd64
zabbix-server-mysql/bionic 1:3.0.12+dfsg-1 amd64
lwk@qwfys:~/Downloads$

Install the mysql installation package

lwk@qwfys:~/Downloads$ apt install mysql-server mysql-client mysql-workbench-community 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  libaio1 libmecab2 libpcrecpp0v5 libssh-4 libvsqlitepp3v5 mysql-common mysql-community-client mysql-community-client-core mysql-community-server mysql-community-server-core
Suggested packages:
  libproj-dev
Recommended packages:
  mecab-ipadic-utf8
The following NEW packages will be installed:
  libaio1 libmecab2 libpcrecpp0v5 libssh-4 libvsqlitepp3v5 mysql-client mysql-common mysql-community-client mysql-community-client-core mysql-community-server mysql-community-server-core mysql-server mysql-workbench-community
0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded.
Need to get 20.0 MB/61.9 MB of archives.
After this operation, 471 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://mirrors.ustc.edu.cn/ubuntu bionic/main amd64 libaio1 amd64 0.3.110-5 [6,448 B]
Get:2 http://mirrors.ustc.edu.cn/ubuntu bionic/universe amd64 libmecab2 amd64 0.996-5 [257 kB]
Get:3 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools amd64 mysql-workbench-community amd64 8.0.12-1ubuntu18.04 [19.5 MB]
Get:4 http://mirrors.ustc.edu.cn/ubuntu bionic/main amd64 libpcrecpp0v5 amd64 2:8.39-9 [15.3 kB]
Get:5 http://mirrors.ustc.edu.cn/ubuntu bionic/main amd64 libssh-4 amd64 0.8.0~20170825.94fa1e38-1build1 [168 kB]
Get:6 http://mirrors.ustc.edu.cn/ubuntu bionic/universe amd64 libvsqlitepp3v5 amd64 0.3.13-4 [44.2 kB]
Fetched 20.0 MB in 4s (5,652 kB/s)                                                      
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 331889 files and directories currently installed.)
Preparing to unpack .../00-mysql-common_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-common (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package mysql-community-client-core.
Preparing to unpack .../01-mysql-community-client-core_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-community-client-core (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package mysql-community-client.
Preparing to unpack .../02-mysql-community-client_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-community-client (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package mysql-client.
Preparing to unpack .../03-mysql-client_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-client (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package libaio1:amd64.
Preparing to unpack .../04-libaio1_0.3.110-5_amd64.deb ...
Unpacking libaio1:amd64 (0.3.110-5) ...
Selecting previously unselected package libmecab2:amd64.
Preparing to unpack .../05-libmecab2_0.996-5_amd64.deb ...
Unpacking libmecab2:amd64 (0.996-5) ...
Selecting previously unselected package mysql-community-server-core.
Preparing to unpack .../06-mysql-community-server-core_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-community-server-core (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package mysql-community-server.
Preparing to unpack .../07-mysql-community-server_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-community-server (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package libpcrecpp0v5:amd64.
Preparing to unpack .../08-libpcrecpp0v5_2%3a8.39-9_amd64.deb ...
Unpacking libpcrecpp0v5:amd64 (2:8.39-9) ...
Selecting previously unselected package libssh-4:amd64.
Preparing to unpack .../09-libssh-4_0.8.0~20170825.94fa1e38-1build1_amd64.deb ...
Unpacking libssh-4:amd64 (0.8.0~20170825.94fa1e38-1build1) ...
Selecting previously unselected package libvsqlitepp3v5:amd64.
Preparing to unpack .../10-libvsqlitepp3v5_0.3.13-4_amd64.deb ...
Unpacking libvsqlitepp3v5:amd64 (0.3.13-4) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../11-mysql-server_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-server (8.0.12-1ubuntu18.04) ...
Selecting previously unselected package mysql-workbench-community.
Preparing to unpack .../12-mysql-workbench-community_8.0.12-1ubuntu18.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.12-1ubuntu18.04) ...
Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for ureadahead (0.100.0-20) ...
Processing triggers for desktop-file-utils (0.23+linuxmint3) ...
Setting up mysql-common (8.0.12-1ubuntu18.04) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up libvsqlitepp3v5:amd64 (0.3.13-4) ...
Setting up libmecab2:amd64 (0.996-5) ...
Setting up mysql-community-client-core (8.0.12-1ubuntu18.04) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Setting up libaio1:amd64 (0.3.110-5) ...
Setting up libssh-4:amd64 (0.8.0~20170825.94fa1e38-1build1) ...
Processing triggers for systemd (237-3ubuntu10.3) ...
Processing triggers for man-db (2.8.3-2) ...
Processing triggers for shared-mime-info (1.9-2) ...
Setting up libpcrecpp0v5:amd64 (2:8.39-9) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Setting up mysql-community-client (8.0.12-1ubuntu18.04) ...
Setting up mysql-workbench-community (8.0.12-1ubuntu18.04) ...
Setting up mysql-client (8.0.12-1ubuntu18.04) ...
Setting up mysql-community-server-core (8.0.12-1ubuntu18.04) ...
Setting up mysql-community-server (8.0.12-1ubuntu18.04) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Setting up mysql-server (8.0.12-1ubuntu18.04) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Processing triggers for systemd (237-3ubuntu10.3) ...
Processing triggers for ureadahead (0.100.0-20) ...
lwk@qwfys:~/Downloads$

Check if mysql is installed successfully

lwk@qwfys:~/Downloads$ systemctl status mysql
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2018-08-05 10:54:38 CST; 23s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
 Main PID: 11958 (mysqld)
   Status: "SERVER_OPERATING"
    Tasks: 37 (limit: 4915)
   CGroup: /system.slice/mysql.service
           └─11958 /usr/sbin/mysqld

Aug 05 10:54:38 qwfys systemd[1]: Starting MySQL Community Server...
Aug 05 10:54:38 qwfys systemd[1]: Started MySQL Community Server.
lwk@qwfys:~/Downloads$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.12 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> 

mysql installation is successful

这个时候,所有的账号只能从本地访问,要想从外部主机访问,还需要将文件/etc/mysql/mysql.conf.d/mysqld.cnf中的"bind-address = 127.0.0.1"一行注释掉。

注释掉以后,重启服务:

lwk@qwfys:~$ sudo systemctl restart mysql.service

转载于:https://my.oschina.net/qwfys200/blog/1922711

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值