Score:0

Not able to start mysql after upgrade from 5,7 to 8 (ubuntu upgrade)

ug flag

After upgrading ubuntu to 22.04 from 18.04 (was planning on upgrading to 20.04 but somehow I ended up with 22.04) I'm not able to start mysql server. The error is as follows:

[ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'

Ive tried adding this to /etc/mysql/.my.cnf to set the sql_mode, but doesn't seem to make a difference.

[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Also when running mysqld --verbose --help the option sql_mode is empty. Downgrading Ubuntu is difficult from what I found on Google wihtout a backup or reinstalling everything. And downgrading mysql is an option, but the backup I have is pretty old, so would prefer to fix it, or just get the existing data somehow... Can anyone point me in the right direction? Thanks.

Wilson Hauck avatar
jp flag
Please post as TEXT the last 100 lines of your error log and complete my.cnf for analysis.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.