LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Password
Ubuntu This forum is for the discussion of Ubuntu Linux.

Notices


Reply
  Search this Thread
Old 08-03-2019, 02:59 PM   #1
Janvanl
Member
 
Registered: Apr 2015
Posts: 145

Rep: Reputation: Disabled
MySQL version-mix after update


Hi,

I run Kubuntu 18.04.

On this was MySQL 5.7.

After the one or the other update the package
mysql-common
has become version 5.8 +1.0.4

The rest like mysql-server and mysql-client are still 5.7.27

Making mysql as a whole dysfunktional.

There are some databases that I would like to keep.
So a new install of mysql is not the desired option.

What is the best way to repair this, anyone an idea?

[edit]
I just restarted mysql with "service mysql restart" and checked with "service mysql status" and the server is running.
I could even start workbench, before workbench crashed with a dependency-problem. This is strange.


regards,
Jan

Last edited by Janvanl; 08-03-2019 at 04:00 PM.
 
Old 08-05-2019, 05:50 AM   #2
ondoho
LQ Addict
 
Registered: Dec 2013
Posts: 19,872
Blog Entries: 12

Rep: Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053
Quote:
Originally Posted by Janvanl View Post
[edit]
I just restarted mysql with "service mysql restart" and checked with "service mysql status" and the server is running.
I could even start workbench, before workbench crashed with a dependency-problem. This is strange.
So all is good now?
Please mark your thread SOLVED.
 
Old 08-05-2019, 06:16 AM   #3
Janvanl
Member
 
Registered: Apr 2015
Posts: 145

Original Poster
Rep: Reputation: Disabled
No this is not OK.

I am trying to figure out how it is possible that packages of 2 mysql versions mix up.

My question is how to get a consistent system again, the way to restart through the console is nice,
but i would like to know if any of us have the same problem, or solved it.

Regards,
Jan
 
Old 08-05-2019, 06:49 AM   #4
ondoho
LQ Addict
 
Registered: Dec 2013
Posts: 19,872
Blog Entries: 12

Rep: Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053
OK.
Code:
apt-cache policy package_name
please, where package_name is each of the packages affected.
 
Old 08-05-2019, 07:38 AM   #5
Janvanl
Member
 
Registered: Apr 2015
Posts: 145

Original Poster
Rep: Reputation: Disabled
Hi,

on my 18.04 Kubuntu Laptop

with apt-cache policy mysql-common
I get 5.8
with apt-cache policy mysql-server
I get 5.7


On my 16.04 Kubuntu both have 5.7.
I do not have problems on the 16.04 machine.


Since downgrading (mysql-common) is not an option (loss of databases)
an update to 5.8 for server and client could be a solution but how, when common already says it is 5.8?

See my problem?

Regards,
Jan
 
Old 08-05-2019, 04:22 PM   #6
ondoho
LQ Addict
 
Registered: Dec 2013
Posts: 19,872
Blog Entries: 12

Rep: Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053
you have to show us the complete output, including the command itself.
Please use CODE tags for that.
While you're at it, also
Code:
apt update
please.
 
Old 08-05-2019, 04:27 PM   #7
Janvanl
Member
 
Registered: Apr 2015
Posts: 145

Original Poster
Rep: Reputation: Disabled
Thanks for the reply.

I will send the output tomorrow.

My PC's are updated every few days, but I will run apt update.

Regards,
Jan
 
Old 08-05-2019, 04:45 PM   #8
ondoho
LQ Addict
 
Registered: Dec 2013
Posts: 19,872
Blog Entries: 12

Rep: Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053
Quote:
Originally Posted by Janvanl View Post
My PC's are updated every few days, but I will run apt update.
that command only updates the list of available software, and not your system.
but it also shows important info about the state of apt on your system.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error :"Cannot mix incompatible Qt library (version 0x50500) with this library (version 0x50501)" when trying to run Binary Blessy Programming 3 07-18-2017 09:35 AM
MySQL server version differs from MySQL client version -- should I fix this? sneakyimp Linux - Server 2 06-27-2014 01:16 PM
can I mix gcc3.2.2 with version 3.3.4 of gcc-java and libgcj-devel? bad_gui Linux - Software 1 09-09-2007 11:11 PM
Java version mix up trebek Ubuntu 3 05-24-2007 10:55 AM
Oignon routing: Mix and mix cascades xpucto Linux - Networking 6 07-05-2006 12:01 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu

All times are GMT -5. The time now is 10:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration