Related

Join the DigitalOcean Community Community

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
 Join Now
Completely uninstall mysql-server Question Question
Assistance with MySQL my.cnf file preventing mysql from starting Question Question

Question

/usr/bin/dpkg returned an error code (1)

Posted August 9, 2020 4.3k views
MySQLUbuntu 20.04

I’ve recently upgraded to Ubuntu 20.04.1 LTS and it tells me that mySQL 8 didn’t update successfully. When I try to follow steps to “Fix” the error I keep getting the same error:

dpkg: error processing package mysql-server (–configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-8.0
mysql-server

Please help!

Add a comment
davidboudia
By:
davidboudia

Related

Join the DigitalOcean Community Community

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
 Join Now
Completely uninstall mysql-server Question Question
Assistance with MySQL my.cnf file preventing mysql from starting Question Question
Add a comment
1 comment
  • davidboudia August 9, 2020
    Reply Report

    FYI - I’ve tried using
    apt install mysql-server
    but that was unsuccessful

    I’ve also tried to install the dependency packages:

    apt-get -f install

    and stil get the same error

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.

×
Submit an Answer
2 answers
alexdo August 9, 2020

Hi, @davidboudia
You can use the following to remove any redundant dependency issues and install a functioning MySQL package

Note: I will strongly recommend you to take a snapshot of the droplet before executing any commands. Further troubleshooting the issue can cause issues with other services and it’s good to have a copy of the current state of the droplet.

sudo apt-get clean
sudo apt-get purge mysql*
sudo apt-get update
sudo apt-get install -f
sudo apt-get install mysql-server-5.7
sudo apt-get dist-upgrade

This should sort the issue for you. Let us know how it goes.

Hope that this helps!
Regards,
Alex

Reply Report
  • davidboudia August 9, 2020

    Hi Alex,

    I tried these or similar and kept getting the same error message. I figured out what the problem was - there is was an erroneous sql-mode that I was using

    NO_AUTO_CREATE_USER

    in the mysql config file. After I removed that, i was able to complete the mysql installation and everything seems to be running fine. Thanks for the response.

    Reply Report
    • alexdo August 10, 2020

      Hi, @davidboudia

      I’m glad you’ve sorted this! Also thank you for sharing what the issue was and how you’ve sorted it as other users can find this useful if they run into the same problem and open this question.

      Regards,
      Alex

      Reply Report
  • mirshakil October 13, 2020

    not solving the problem

    Reply Report
alexdo October 18, 2020

Hey mirshakil

Would you mind sharing more information about the issue that you’re currently experiencing?

Regards,
Alex

Reply Report

Related

Looking for something else?

Ask a new question Search for more help