Menu
After Fedora 28 decided to upgrade mysql-community packages to 8.0 (latest) ,I realized my application was failing and had to downgrade to mysql 5.27.2
Of course my db files (.idb) were the same (altered by mysql 8.0). When starting mysql 5.27 service, it fails. I have read the log file /var/log/mysqld.log and found this:
InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4000!
305
If you have the MySQL already installed on your windows, then go to the Services by executing "services. msc" run command or from the Start menu on your windows and right-click the MySQL file and then stop the service, now open your XAMPP and start MySQL. Now the MySQL will start on the port 3306.
Restart the machine and try Instance Configuration Again. Uninstall all MySQL software and making sure that there was no service and reinstall. search registry to make sure there was no MySQL entries.
This problem was solved removing all database files:
sudo rm -rf /var/lib/mysql/*
Please be aware you will lose every database in the server by doing this!!! In my case I had a dump and i could restore.
106
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With