文档章节

install mysql 8.0 to Linux mint 19.0

qwfys
 qwfys
发布于 08/05 09:38
字数 2395
阅读 33
收藏 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

© 著作权归作者所有

共有 人打赏支持
qwfys
粉丝 6
博文 142
码字总数 117416
作品 0
杭州
架构师
私信 提问
Linux Mint 12 正式版已经发布

Linux Mint 12 正式版已经发布,Linux Mint 亲们可以从以下地址下载 : http://ftp.heanet.ie/pub/linuxmint.com/stable/12/ Linux Mint 12 的开发代号为 Lida 。 - 亮点: 基于 Ubuntu 11....

红薯
2011/11/24
6.6K
28
Install Jetbrains Idea 2018.2 to Linux mint 19.0

Install Jetbrains Idea 2018.2 to Linux mint 19.0 启动画面 配置 配置启动项 取消代码折叠 设置字体 设置Console字体 设置文件编码 去掉 No data sources configure 警告 去掉 SQL dialec...

qwfys
08/08
0
0
linux mint 19.0 partition

If you continue, the changes listed below will be written to the disks. Otherwise, you will be able to make further changes manually. WARNING: This will destroy all data on any ......

qwfys
06/30
0
0
Debian 8.0 "Jessie" 功能已经冻结

Debian 是最大和最久的 Linux 发行版之一,有很多在 Debian 基础上衍生出来的著名发行版,包括 Ubunut、Linux Mint 和 Raspbian 等。 Debian 项目本周 宣布 测试的代码库,代号为 Jessie 的 ...

oschina
2014/11/08
6.1K
11
Vim 8.0横空出世

Vi 编辑器至 1976 年发布以来已经存在很长时间了,它不仅为用户提供了高效的编辑界面、终端控制等功能,还为我们提供了很多传统而实用的功能。但不足的是,Vi 编辑器还缺乏多屏、语法高亮、多...

linuxprobe
2016/09/25
0
0

没有更多内容

加载失败,请刷新页面

加载更多

java框架学习日志-7(静态代理和JDK代理)

静态代理 我们平时去餐厅吃饭,不是直接告诉厨师做什么菜的,而是先告诉服务员点什么菜,然后由服务员传到给厨师,相当于服务员是厨师的代理,我们通过代理让厨师炒菜,这就是代理模式。代理...

白话
今天
20
0
Flink Window

1.Flink窗口 Window Assigner分配器。 窗口可以是时间驱动的(Time Window,例如:每30秒钟),也可以是数据驱动的(Count Window,例如:每一百个元素)。 一种经典的窗口分类可以分成: 翻...

满小茂
今天
15
0
my.ini

1

architect刘源源
今天
12
0
docker dns

There is a opensource application that solves this issue, it's called DNS Proxy Server It's a DNS server that solves containers hostnames, if could not found a hostname that mat......

kut
今天
14
0
寻找数学的广度——《这才是数学》读书笔记2700字

寻找数学的广度——《这才是数学》读书笔记2700字: 文|程哲。数学学习方式之广:国内外数学教育方面的专家,进行了很多种不同的数学学习方式尝试,如数学绘本、数学游戏、数学实验、数学步道...

原创小博客
今天
25
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部