-- Steps followed from https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ ushastry@Debian10:~/Downloads$ cat /etc/*release PRETTY_NAME="Debian GNU/Linux 10 (buster)" NAME="Debian GNU/Linux" VERSION_ID="10" VERSION="10 (buster)" VERSION_CODENAME=buster ID=debian HOME_URL="https://www.debian.org/" SUPPORT_URL="https://www.debian.org/support" BUG_REPORT_URL="https://bugs.debian.org/" root@Debian10:/home/ushastry/Downloads# uname -r; lsb_release -r 4.19.0-9-amd64 Release: 10 - root@Debian10:/home/ushastry/Downloads# dpkg -i mysql-apt-config_0.8.15-1_all.deb Selecting previously unselected package mysql-apt-config. (Reading database ... 156784 files and directories currently installed.) Preparing to unpack mysql-apt-config_0.8.15-1_all.deb ... Unpacking mysql-apt-config (0.8.15-1) ... Setting up mysql-apt-config (0.8.15-1) ... Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config) OK root@Debian10:/home/ushastry/Downloads# root@Debian10:/home/ushastry/Downloads# apt update Hit:1 http://security.debian.org/debian-security buster/updates InRelease Get:2 http://repo.mysql.com/apt/debian buster InRelease [21.5 kB] Hit:3 http://deb.debian.org/debian buster InRelease Get:4 http://repo.mysql.com/apt/debian buster/mysql-8.0 Sources [938 B] Get:5 http://repo.mysql.com/apt/debian buster/mysql-apt-config amd64 Packages [563 B] Get:6 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 Packages [7,172 B] Get:7 http://repo.mysql.com/apt/debian buster/mysql-tools amd64 Packages [5,403 B] Fetched 35.6 kB in 4s (8,309 B/s) Reading package lists... Done Building dependency tree Reading state information... Done 1 package can be upgraded. Run 'apt list --upgradable' to see it. root@Debian10:/home/ushastry/Downloads# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libaio1 libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client mysql-common mysql-community-client mysql-community-client-core mysql-community-server mysql-community-server-core The following NEW packages will be installed: libaio1 libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client mysql-community-client mysql-community-client-core mysql-community-server mysql-community-server-core mysql-server The following packages will be upgraded: mysql-common 1 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. Need to get 34.2 MB of archives. After this operation, 313 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://deb.debian.org/debian buster/main amd64 libaio1 amd64 0.3.112-3 [11.2 kB] Get:2 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-common amd64 8.0.21-1debian10 [94.3 kB] Get:3 http://deb.debian.org/debian buster/main amd64 libmecab2 amd64 0.996-6 [258 kB] Get:4 http://deb.debian.org/debian buster/main amd64 mecab-utils amd64 0.996-6 [7,700 B] Get:5 http://deb.debian.org/debian buster/main amd64 mecab-ipadic all 2.7.0-20070801+main-2.1 [6,714 kB] Get:6 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-community-client-core amd64 8.0.21-1debian10 [1,797 kB] Get:7 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-community-client amd64 8.0.21-1debian10 [2,998 kB] Get:8 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-client amd64 8.0.21-1debian10 [90.8 kB] Get:9 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-community-server-core amd64 8.0.21-1debian10 [22.0 MB] Get:10 http://deb.debian.org/debian buster/main amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-2.1 [5,356 B] Get:11 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-community-server amd64 8.0.21-1debian10 [101 kB] Get:12 http://repo.mysql.com/apt/debian buster/mysql-8.0 amd64 mysql-server amd64 8.0.21-1debian10 [90.8 kB] Fetched 34.2 MB in 1min 26s (395 kB/s) Reading changelogs... Done Preconfiguring packages ... (Reading database ... 156789 files and directories currently installed.) Preparing to unpack .../00-mysql-common_8.0.21-1debian10_amd64.deb ... Unpacking mysql-common (8.0.21-1debian10) over (5.8+1.0.5) ... Selecting previously unselected package mysql-community-client-core. Preparing to unpack .../01-mysql-community-client-core_8.0.21-1debian10_amd64.deb ... Unpacking mysql-community-client-core (8.0.21-1debian10) ... Selecting previously unselected package mysql-community-client. Preparing to unpack .../02-mysql-community-client_8.0.21-1debian10_amd64.deb ... Unpacking mysql-community-client (8.0.21-1debian10) ... Selecting previously unselected package mysql-client. Preparing to unpack .../03-mysql-client_8.0.21-1debian10_amd64.deb ... Unpacking mysql-client (8.0.21-1debian10) ... Selecting previously unselected package libaio1:amd64. Preparing to unpack .../04-libaio1_0.3.112-3_amd64.deb ... Unpacking libaio1:amd64 (0.3.112-3) ... Selecting previously unselected package libmecab2:amd64. Preparing to unpack .../05-libmecab2_0.996-6_amd64.deb ... Unpacking libmecab2:amd64 (0.996-6) ... Selecting previously unselected package mysql-community-server-core. Preparing to unpack .../06-mysql-community-server-core_8.0.21-1debian10_amd64.deb ... Unpacking mysql-community-server-core (8.0.21-1debian10) ... Selecting previously unselected package mysql-community-server. Preparing to unpack .../07-mysql-community-server_8.0.21-1debian10_amd64.deb ... Unpacking mysql-community-server (8.0.21-1debian10) ... Selecting previously unselected package mecab-utils. Preparing to unpack .../08-mecab-utils_0.996-6_amd64.deb ... Unpacking mecab-utils (0.996-6) ... Selecting previously unselected package mecab-ipadic. Preparing to unpack .../09-mecab-ipadic_2.7.0-20070801+main-2.1_all.deb ... Unpacking mecab-ipadic (2.7.0-20070801+main-2.1) ... Selecting previously unselected package mecab-ipadic-utf8. Preparing to unpack .../10-mecab-ipadic-utf8_2.7.0-20070801+main-2.1_all.deb ... Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ... Selecting previously unselected package mysql-server. Preparing to unpack .../11-mysql-server_8.0.21-1debian10_amd64.deb ... Unpacking mysql-server (8.0.21-1debian10) ... Setting up libmecab2:amd64 (0.996-6) ... Setting up mysql-common (8.0.21-1debian10) ... Installing new version of config file /etc/mysql/conf.d/mysql.cnf ... Installing new version of config file /etc/mysql/my.cnf.fallback ... Setting up mysql-community-client-core (8.0.21-1debian10) ... Setting up mecab-utils (0.996-6) ... Setting up libaio1:amd64 (0.3.112-3) ... Setting up mysql-community-client (8.0.21-1debian10) ... Setting up mysql-client (8.0.21-1debian10) ... Setting up mecab-ipadic (2.7.0-20070801+main-2.1) ... Compiling IPA dictionary for Mecab. This takes long time... reading /usr/share/mecab/dic/ipadic/unk.def ... 40 emitting double-array: 100% |###########################################| /usr/share/mecab/dic/ipadic/model.def is not found. skipped. reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135 reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210 reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202 reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42 reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795 reading /usr/share/mecab/dic/ipadic/Others.csv ... 2 reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199 reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146 reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750 reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221 reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146 reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91 reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328 reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208 reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032 reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19 reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668 reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120 reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328 reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999 reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42 reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252 reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151 reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171 reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393 reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477 emitting double-array: 100% |###########################################| reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316 emitting matrix : 100% |###########################################| done! update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode Setting up mysql-community-server-core (8.0.21-1debian10) ... Setting up mysql-community-server (8.0.21-1debian10) ... 2020-08-01T10:14:22.089526Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.21) initializing of server in progress as process 3695 2020-08-01T10:14:22.100372Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-08-01T10:14:24.311693Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-08-01T10:14:28.202796Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service. [mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly. [mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly. [mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly. Setting up mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ... Compiling IPA dictionary for Mecab. This takes long time... reading /usr/share/mecab/dic/ipadic/unk.def ... 40 emitting double-array: 100% |###########################################| /usr/share/mecab/dic/ipadic/model.def is not found. skipped. reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135 reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210 reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202 reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42 reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795 reading /usr/share/mecab/dic/ipadic/Others.csv ... 2 reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199 reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146 reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750 reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221 reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146 reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91 reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328 reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208 reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032 reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19 reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668 reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120 reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328 reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999 reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42 reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252 reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151 reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171 reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393 reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477 emitting double-array: 100% |###########################################| reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316 emitting matrix : 100% |###########################################| done! update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode Setting up mysql-server (8.0.21-1debian10) ... Processing triggers for man-db (2.8.5-2) ... Processing triggers for libc-bin (2.28-10) ... - root@Debian10:/home/ushastry/Downloads# dpkg -l|grep -i mysql ii mysql-apt-config 0.8.15-1 all Auto configuration for MySQL APT Repo. ii mysql-client 8.0.21-1debian10 amd64 MySQL Client meta package depending on latest version ii mysql-common 8.0.21-1debian10 amd64 Common files shared between packages ii mysql-community-client 8.0.21-1debian10 amd64 MySQL Client ii mysql-community-client-core 8.0.21-1debian10 amd64 MySQL Client Core Binaries ii mysql-community-server 8.0.21-1debian10 amd64 MySQL Server ii mysql-community-server-core 8.0.21-1debian10 amd64 MySQL Server Core Binaires ii mysql-server 8.0.21-1debian10 amd64 MySQL Server meta package depending on latest version root@Debian10:/home/ushastry/Downloads# service mysql status ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Sat 2020-08-01 06:19:52 EDT; 4min 53s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 4384 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 4419 (mysqld) Status: "Server is operational" Tasks: 39 (limit: 4915) Memory: 340.1M CGroup: /system.slice/mysql.service └─4419 /usr/sbin/mysqld Aug 01 06:19:51 Debian10 systemd[1]: Starting MySQL Community Server... Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.152562Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 4419 Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.164334Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.473867Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.645436Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.787510Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.787761Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. Aug 01 06:19:52 Debian10 mysqld[4419]: 2020-08-01T10:19:52.816548Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21' socket: '/var/run/mysqld/mysqld.sock' port: 3306 M Aug 01 06:19:52 Debian10 systemd[1]: Started MySQL Community Server. root@Debian10:/home/ushastry/Downloads# root@Debian10:/home/ushastry/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.21 MySQL Community Server - GPL Copyright (c) 2000, 2020, 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> show variables like 'secure%'; +------------------+-----------------------+ | Variable_name | Value | +------------------+-----------------------+ | secure_file_priv | /var/lib/mysql-files/ | +------------------+-----------------------+ 1 row in set (0.01 sec) mysql> \q Bye root@Debian10:/home/ushastry/Downloads# ls -l /var/lib/mysql-files/ total 0 root@Debian10:/home/ushastry/Downloads# service mysql stop -- Copied options listed by reporter and included in /etc/my.cnf ( had no impact whatsoever when I added to /etc/mysql/mysql.conf.d/mysqld.cnf) root@Debian10:/home/ushastry/Downloads# vi /etc/my.cnf root@Debian10:/home/ushastry/Downloads# cat /etc/my.cnf [mysqld] character-set-filesystem = utf8mb4 secure-file-priv = NULL wait-timeout = 30 interactive-timeout = 300 ssl = 0 auto-generate-certs = 0 mysqlx = 0 mysqlx-cache-cleaner = 0 persisted-globals-load = 0 skip-name-resolve skip-networking ft-min-word-len = 3 ft-max-word-len = 64 myisam-recover-options = BACKUP,FORCE root@Debian10:/home/ushastry/Downloads# ls -ld /NULL ls: cannot access '/NULL': No such file or directory root@Debian10:/home/ushastry/Downloads# root@Debian10:/home/ushastry/Downloads# service mysql start root@Debian10:/home/ushastry/Downloads# root@Debian10:/home/ushastry/Downloads# ls -ld /NULL drwxrwx--- 2 mysql mysql 4096 Aug 1 06:25 /NULL root@Debian10:/home/ushastry/Downloads# root@Debian10:/home/ushastry/Downloads# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.21 MySQL Community Server - GPL Copyright (c) 2000, 2020, 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> show variables like 'secure%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | secure_file_priv | NULL | +------------------+-------+ 1 row in set (0.00 sec) mysql>