系统版本：ubantu 20.4.4
MySQL版本：8.30
app@app:/data/mysql$ dpkg --list |grep mysql rc mysql-community-client 5.7.25-1ubuntu18.10 amd64 MySQL Client rc mysql-community-server 5.7.25-1ubuntu18.10 amd64 MySQL Server ii mysql-community-source 5.7.25-1ubuntu18.10 amd64 MySQL source app@app:/data/mysql$ sudo apt-get remove mysql-community-client --purge Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be REMOVED: mysql-community-client* 0 upgraded, 0 newly installed, 1 to remove and 50 not upgraded. After this operation, 0 B of additional disk space will be used. Do you want to continue? [Y/n] y (Reading database ... 123864 files and directories currently installed.) Purging configuration files for mysql-community-client (5.7.25-1ubuntu18.10) ...
--purge 参数是卸载的同时把配置文件一并删除下载MySQL
1、sudo mkdir /data/mysql8.0 -p 2、cd /data/mysql8.0/ 3、sudo wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-server_8.0.30-1ubuntu20.04_amd64.deb-bundle.tar 如果没有wgt，执行sodu api-get install wget 安装即可
注意：需要关注ubuntu的版本，我的系统为20.4.4，下载对应系统的版本解压tar包
tar xf mysql-server_8.0.30-1ubuntu20.04_amd64.deb-bundle.tar 参数解释：xf 解压文件安装MySQL
#### 删除test相关的包 app@app:/data/mysql8.30$ ls *test* -l -rw-r--r-- 1 app app 255532636 Jul 7 05:33 mysql-community-test_8.0.30-1ubuntu20.04_amd64.deb -rw-r--r-- 1 app app 13224520 Jul 7 05:33 mysql-community-test-debug_8.0.30-1ubuntu20.04_amd64.deb -rw-r--r-- 1 app app 68272 Jul 7 05:33 mysql-testsuite_8.0.30-1ubuntu20.04_amd64.deb rm -fr *test* app@app:/data/mysql8.30$ ls *test* -l ls: cannot access '*test*': No such file or directory 安装MySQL sudo dpkg -i mysql-*.deb
输入密码并回车，确认密码继续回车
注意，此处回车为使用强度高的密码进行验证，下面一个选项为旧的密码验证，8.0版本为安全度较高的版本，所以此处继续回车等待安装完成即可。
app@app:/data/mysql8.30$ dpkg --list |grep mysql
ii mysql-client 8.0.30-1ubuntu20.04 amd64 MySQL Client meta package depending on latest version
ii mysql-common 8.0.30-1ubuntu20.04 amd64 Common files shared between packages
ii mysql-community-client 8.0.30-1ubuntu20.04 amd64 MySQL Client
ii mysql-community-client-core 8.0.30-1ubuntu20.04 amd64 MySQL Client Core Binaries
ii mysql-community-client-plugins 8.0.30-1ubuntu20.04 amd64 MySQL Client plugin
ii mysql-community-server 8.0.30-1ubuntu20.04 amd64 MySQL Server
ii mysql-community-server-core 8.0.30-1ubuntu20.04 amd64 MySQL Server Core Binaires
ii mysql-community-server-debug 8.0.30-1ubuntu20.04 amd64 Debug binaries for MySQL Server
ii mysql-server 8.0.30-1ubuntu20.04 amd64 MySQL Server meta package depending on latest version
app@app:/data/mysql8.30$ ps -ef |grep mysql
mysql 625955 1 1 09:48 ? 00:00:01 /usr/sbin/mysqld
app 626319 621358 0 09:50 pts/0 00:00:00 grep --color=auto mysql
app@app:/data/mysql8.30$ systemctl status mysql
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2022-07-28 09:48:56 CST; 2min 14s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Main PID: 625955 (mysqld)
Status: "Server is operational"
Tasks: 38 (limit: 9443)
Memory: 360.4M
CGroup: /system.slice/mysql.service
└─625955 /usr/sbin/mysqld
Jul 28 09:48:54 app systemd[1]: Starting MySQL Community Server...
Jul 28 09:48:56 app systemd[1]: Started MySQL Community Server.
至此MySQL已经安装完成，但是还需要调试优化。
优化sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 追加到末尾 # 修改标签长度，默认1024 group_concat_max_len = 10240 # 最大睡眠时间 wait_timeout=300 # 超时时间设置 interactive_timeout = 500 # 允许最大的上传大小，默认1M max_allowed_packet = 64M # 指定字符编码 character_set_server=utf8mb4配置密码复杂度
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 追加到末尾 plugin-load=validate_password.so validate_password_policy=0 validate-password=FORCE_PLUS_PERMANENT ###重启MySQL sudo systemctl restart mysql ###登录mysql查看密码复杂度 app@app:~$ mysql -uroot -p123.com mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 8 Server version: 8.0.30 MySQL Community Server - GPL Copyright (c) 2000, 2022, Oracle and/or its affiliates. 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 'validate%'; +--------------------------------------+-------+ | Variable_name | Value | +--------------------------------------+-------+ | validate_password_check_user_name | ON | | validate_password_dictionary_file | | | validate_password_length | 8 | | validate_password_mixed_case_count | 1 | | validate_password_number_count | 1 | | validate_password_policy | LOW | | validate_password_special_char_count | 1 | +--------------------------------------+-------+ 7 rows in set (0.01 sec) validate_password_check_user_name : 默认关闭，设置为ON时可以将密码设置成当前用户名 validate_password_dictionary_file : 检查密码的字典文件的路径名 validate_password_length : 默认为8，限制密码长度的最小字符数 validate_password_mixed_case_count : 默认值为1，限制小写字符和大写字符个数 validate_password_number_count : 默认值为1，限制数字的个数 validate_password_policy : 默认值为1, 密码强度等级 [LOW:0| MEDIUM:1 | STRONG:2] validate_password_special_char_count : 默认值为1，限制特殊字符个数 validate_password_policy 0/LOW：只检查长度。 1/MEDIUM：检查长度、数字、大小写、特殊字符。 2/STRONG：检查长度、数字、大小写、特殊字符字典文件 ###配置密码复杂度 mysql> set global validate_password_policy=0; Query OK, 0 rows affected (0.00 sec) mysql> show variables like 'validate%'; +--------------------------------------+-------+ | Variable_name | Value | +--------------------------------------+-------+ | validate_password_check_user_name | ON | | validate_password_dictionary_file | | | validate_password_length | 8 | | validate_password_mixed_case_count | 1 | | validate_password_number_count | 1 | | validate_password_policy | LOW | | validate_password_special_char_count | 1 | +--------------------------------------+-------+ 7 rows in set (0.00 sec) ###修改密码 mysql> alter user 'root'@'localhost' identified with mysql_native_password by '11111111'; Query OK, 0 rows affected (0.03 sec) ###授权远程登录 mysql> select host,user from user; +-----------+------------------+ | host | user | +-----------+------------------+ | localhost | mysql.infoschema | | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-----------+------------------+ 4 rows in set (0.00 sec) mysql> use mysql mysql> update user set host='%' where user='root'; Query OK, 1 row affected (0.03 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec)
