Debian 11 x64 安装 MySQL 8.0.33

sudo apt update
sudo apt install gnupg

wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.25-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.25-1_all.deb

sudo apt update

sudo apt-get install mysql-community-server

systemctl status mysql.service

sudo mysql_secure_installation

sudo mysqladmin -u root -p version

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address=127.0.0.1

sudo ufw allow 3306/tcp

systemctl restart mysql

sudo mysql -u root -p

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

create user your_name identified by 'your_password';

grant all privileges on  *.* to 'your_name'@'%';

FLUSH PRIVILEGES;

GRANT ALL ON *.* TO 'your_name'@'233.233.233.233' IDENTIFIED BY 'your_password' WITH GRANT OPTION;

systemctl list-unit-files | grep enabled

sudo systemctl enable mysql