Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
After upgrading to Ubuntu20 from Ubuntu18, mysql is not working.
I upgraded from Ubuntu 18 to Ubuntu 20. mySQL upgrade failed during the upgrade.
After the upgrade, I again tried to install mysql-server. I’m getting the below error:
Error while setting value 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
sudo apt install mysql-server
I used the above command after upgrade to Ubuntu20.
I even tried to edit the configuration, but that didn’t help.
Added the above two lines in
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×