Unable to start msyqld service after modifying datadir from default /var/lib/mysql to /u01/mysql
Hi,
Mysql Version : Server version: 8.0.22 MySQL Community Server - GPL
OS Version : OEL 7.9
I am unable to start mysqld service after I changed datadir location from default /var/lib/mysql to /u01/mysql
2020-12-22T13:28:34.343524Z 0 [Warning] [MY-010091] [Server] Can't create test file /u01/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2020-12-22T13:28:34.343623Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 68273
2020-12-22T13:28:34.348703Z 0 [Warning] [MY-010091] [Server] Can't create test file /u01/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2020-12-22T13:28:34.348716Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /u01/mysql/ is case insensitive
2020-12-22T13:28:34.349653Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-12-22T13:28:34.349907Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22) MySQL Community Server - GPL.
Please help to fix this issue.
Best Regards
Jamsher
Subject
Written By
Posted
Unable to start msyqld service after modifying datadir from default /var/lib/mysql to /u01/mysql
December 22, 2020 07:52AM
December 22, 2020 10:00AM
December 23, 2020 01:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.