Hello Community,
I was curious if anyone has run across this issue when trying to install Percona 5.7.13. The install from Percona yum packages for CentOS 7 goes fine, however the database won’t initialize.
When “systemctl start mysqld.service” is issued I get the following error message:
[error] --initialize specified but the data directory has files in it. Aborting.
I have repeatly deleted the mysql directory at /var/lib/mysql and rerun “systemctl start mysqld.service” and same message and no root password is generated. I can manually issue “mysqld --initialize --user=mysql --defaults-file=/etc/my.cnf” and get a root password. However the database still won’t load.
I was able to bring 5.7 up on another node a month ago with zero issues. I am not really not sure why 5.7 won’t initialize itself. The directory and all permissions are own by MySQL. My understanding is Percona thinks there is another database and thus aborts the start up process.
Yes I looked over https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
Nothing on that page lead to any assistance as this version just doesn’t seem to want to initialize itself.
SELinux is off.
Anyone have any thoughts?
Thanks!
Respectfully,
Jeremy