mysql:设置默认的default_collation_for_utf8mb4？

Question

如何将"default_collation_for_utf8mb4“的值设置为"utf8mb4_general_ci"，全局设置，还是在MySQL8.0服务器启动时设置？

我试过了

[mysqld]
init_connect='SET default_collation_for_utf8mb4=utf8mb4_general_ci'
collation_server = utf8mb4_general_ci
character_set_server = utf8mb4

但还是不起作用。仍然显示"utf8mb4_0900_ai_ci“的值。

 >show variables like "%collation%";
+-------------------------------+--------------------+
| Variable_name                 | Value              |
+-------------------------------+--------------------+
| default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci |

Answer 1

mysql> show variables like "default_collation_for_utf8mb4";
+-------------------------------+--------------------+
| Variable_name                 | Value              |
+-------------------------------+--------------------+
| default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci |
+-------------------------------+--------------------+
1 row in set (0.00 sec)

mysql> SET PERSIST default_collation_for_utf8mb4='utf8mb4_general_ci';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+--------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                |
+---------+------+--------------------------------------------------------------------------------------------------------+
| Warning | 1681 | Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release. |
+---------+------+--------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
root@0273bbf363a9:/etc/mysql/mysql.conf.d# /etc/init.d/mysql status
 * Percona Server 8.0.29-21 is running
root@0273bbf363a9:/etc/mysql/mysql.conf.d# /etc/init.d/mysql restart
 * Stopping Percona Server 8.0.29-21
..
 * Percona Server 8.0.29-21 is stopped
 * Re-starting Percona Server 8.0.29-21
..
 * Percona Server 8.0.29-21 is started
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like "default_collation_for_utf8mb4";
+-------------------------------+--------------------+
| Variable_name                 | Value              |
+-------------------------------+--------------------+
| default_collation_for_utf8mb4 | utf8mb4_general_ci |
+-------------------------------+--------------------+
1 row in set (0.01 sec)