MySQL 8, MX Linux

Update repos:

sudo apt update

install gnupg package

sudo apt install gnupg

Download dep file from https://dev.mysql.com/downloads/repo/apt/
For example:

cd && wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb

Install:

sudo dpkg -i mysql-apt-config*

Update again repos

sudo apt update

Install MySQL 8:

sudo apt install mysql-server

sudo systemctl status mysql

Operate in IP level:

DROP USER "root"@"localhost";
FLUSH PRIVILEGES;
CREATE USER "root"@"127.0.0.1" IDENTIFIED BY "zabbix";
ALTER USER "root"@"127.0.0.1" IDENTIFIED WITH mysql_native_password BY "zabbix";
FLUSH PRIVILEGES;

Set passwordless access:

cat << 'EOF' > ~/.my.cnf
[client]
host=127.0.0.1
user=root
password=zabbix
EOF
sudo chmod 600 ~/.my.cnf