Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

mysqld service won't start

Tags:

mysql

innodb

fedora-28

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!

like image 305
jmojico Avatar asked May 22 '18 13:05

jmojico

People also ask

How do I fix attempting to start MySQL service?

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.

Can't start MySQL service while installing?

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.

1 Answers

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.

like image 106
jmojico Avatar answered Sep 18 '22 18:09

jmojico
Sign in to Comment

Related questions

LEFT JOIN after GROUP BY?
Max size of UNIQUE index in MySQL
Does MySQL "SELECT LIMIT 1" with multiple records select first record from the top?
Is Redis faster than MySQL?
Left Join outperforming Inner Join?
Is using mysql ENUM a bad architectural solution?
Convert mysql query results to CSV (with copy/paste)
MySQL Full-text Search Workaround for innoDB tables
Illegal mix of collations in stored procedure
MySQL: How to efficiently count the number of rows in a large table?
Binding parameters for WHERE IN clause with PDO
Why do I need to flush the connection pool each time I redeploy?
MySQL Closure Table hierarchical database - How to pull information out in the correct order
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) within stored procedure
Is it possible for a mysql query to return true/false instead of values?
Using database in AngularJS - where should I write DB connection code?
limit vs exists vs count(*) vs count(id) in MySQL [duplicate]
MySQL For Visual Studio 2012/2013
Create table with date column
MySQL's HEX() and UNHEX() equivalent in Postgres?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!