改了下tmp的路径,mysql权限不够

mysql | mysqld: Can’t create/write to file ‘/tmp/ibmE52dd’ (OS errno 13 - Permission denied)
mysql | 2024-07-18T11:53:06.512296Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file inside “/tmp”; errno: 13
mysql | 2024-07-18T11:53:06.512320Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
mysql | 2024-07-18T11:53:06.512352Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
mysql | 2024-07-18T11:53:06.512501Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
mysql | 2024-07-18T11:53:06.512532Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql | 2024-07-18T11:53:06.512875Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
mysql | 2024-07-18T11:53:06.513465Z 0 [System] [MY-015016] [Server] MySQL Server - end.
mysql | 2024-07-18 19:53:13+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
mysql | 2024-07-18 19:53:13+08:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
mysql | 2024-07-18 19:53:13+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
mysql | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
mysql | 2024-07-18T11:53:13.503344Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql | 2024-07-18T11:53:13.688312Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
mysql | 2024-07-18T11:53:13.689266Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.
mysql | 2024-07-18T11:53:13.689288Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
mysql | 2024-07-18T11:53:13.690984Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
mysql | 2024-07-18T11:53:13.694649Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql | mysqld: Can’t create/write to file ‘/tmp/ibSRvt22’ (OS errno 13 - Permission denied)
mysql | 2024-07-18T11:53:13.703859Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file inside “/tmp”; errno: 13
mysql | 2024-07-18T11:53:13.703894Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
mysql | 2024-07-18T11:53:13.703931Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
mysql | 2024-07-18T11:53:13.704240Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
mysql | 2024-07-18T11:53:13.704257Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql | 2024-07-18T11:53:13.704592Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
mysql | 2024-07-18T11:53:13.705179Z 0 [System] [MY-015016] [Server] MySQL Server - end.
mysql | 2024-07-18 19:53:26+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
mysql | 2024-07-18 19:53:26+08:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
mysql | 2024-07-18 19:53:26+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
mysql | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
mysql | 2024-07-18T11:53:27.041558Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql | 2024-07-18T11:53:27.227810Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
mysql | 2024-07-18T11:53:27.228760Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.
mysql | 2024-07-18T11:53:27.228791Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
mysql | 2024-07-18T11:53:27.230005Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
mysql | 2024-07-18T11:53:27.233700Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql | mysqld: Can’t create/write to file ‘/tmp/ibVGOgok’ (OS errno 13 - Permission denied)
mysql | 2024-07-18T11:53:27.238287Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file inside “/tmp”; errno: 13
mysql | 2024-07-18T11:53:27.238308Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
mysql | 2024-07-18T11:53:27.238327Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
mysql | 2024-07-18T11:53:27.238434Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
mysql | 2024-07-18T11:53:27.238451Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql | 2024-07-18T11:53:27.238762Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
mysql | 2024-07-18T11:53:27.239394Z 0 [System] [MY-015016] [Server] MySQL Server - end.
mysql | 2024-07-18 19:53:53+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
mysql | 2024-07-18 19:53:53+08:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
mysql | 2024-07-18 19:53:53+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
mysql | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
mysql | 2024-07-18T11:53:53.346899Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql | 2024-07-18T11:53:53.529097Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
mysql | 2024-07-18T11:53:53.530088Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.
mysql | 2024-07-18T11:53:53.530110Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
mysql | 2024-07-18T11:53:53.531411Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
mysql | 2024-07-18T11:53:53.535117Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql | mysqld: Can’t create/write to file ‘/tmp/ib2ssFAo’ (OS errno 13 - Permission denied)
mysql | 2024-07-18T11:53:53.539823Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file inside “/tmp”; errno: 13
mysql | 2024-07-18T11:53:53.539841Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
mysql | 2024-07-18T11:53:53.539864Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
mysql | 2024-07-18T11:53:53.539975Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
mysql | 2024-07-18T11:53:53.539990Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql | 2024-07-18T11:53:53.540423Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
mysql | 2024-07-18T11:53:53.541017Z 0 [System] [MY-015016] [Server] MySQL Server - end.


这样可以启动了,不知道这个方法野不野,tmp权限不够启动不了,改不了容器内的tmp权限