Misconfigured Security Context Constraints Lead to MySQL Pod Failure

Issue

• Deploying mysql-persistent template cannot mount PV while a service account has anyuid scc and fails with below mentioned error:

[Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2023-08-24T04:23:38.027514Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2023-08-24T04:23:38.027602Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.32) starting as process 25
2023-08-24T04:23:38.029548Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2023-08-24T04:23:38.029559Z 0 [ERROR] [MY-010158] [Server] The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination. Please consider either using a case sensitive file system for your data directory or switching to a case-insensitive table name mode.
2023-08-24T04:23:38.029601Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-08-24T04:23:38.029701Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.32) Source distribution.