2

I used sudo apt upgrade and got this:

E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem. 

So I did it and I see this for more than an hour.

Setting up mysql-server-5.7 (5.7.25-0ubuntu0.18.04.2) ...
Checking if update is needed.
This installation of MySQL is already upgraded to 5.7.25, use --force if you still need to run mysql_upgrade

Nothing happens. I have not used MySQL for a long time and don't know what should I do. Understand there must be something with force but I am new with Ubuntu and not so familiar with commands. Can you help me? I don't understand nor what the problem is...:(

UPDATE: I can use MySQL Workbench and get access in Terminal too, but still keep seeing that error

  • what is the welcome output when you try to login to MySQL, and have you checked error messages inside MySQL logs? you can also do mysql check mysqlcheck myschema.mytable to check tables – Ahmad Abuhasna Jan 30 at 9:44
  • 1
    @AhmadAbuhasna I can use MySQL Workbench and get access in Terminal too, but still keep seeing that error – Nicole Jan 31 at 13:24
0

You can check your upgrade and fix any minor issues using these commands:

mysqlcheck --no-defaults --all-databases --fix-db-names --fix-table-names
mysqlcheck --no-defaults --check-upgrade --all-databases --auto-repair

They will tell you what is really going on on your database and fix any major issue they encounter within the database itself.

  • Thank you, everything is OK, but I have the warnings for --fix-db-names and --fix-table-names that say is deprecated and will be removed in a future version so I can't fix those :/ – Nicole Feb 1 at 13:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.