LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 08-23-2019, 12:36 AM   #1
dushyantg
Member
 
Registered: Jun 2016
Posts: 70

Rep: Reputation: Disabled
Unable to install two different mysql versions on CentOS7


Hi,

I am trying to install mysql 5.6 and mysql 8 on CentOS7. as generally I have practice of installing older version first and than the newer version needs to be installed but while doing so it automatically upgrade the old version and mysql 5.6 becomes mysql 8.

I have tried revers way installed mysql 8 first and tried installing 5.6 than it starts giving conflict error.

I have tried installing the same via rpm packages too but happening the same.

Can any one help me out with this. as i want to run two different mysql on my server, please let me know else let me know what is the proper way to do so if I am doing any thing wrong.

Thanks.
 
Old 08-23-2019, 05:18 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,163
Blog Entries: 1

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
Quote:
Originally Posted by dushyantg View Post
Hi,

I am trying to install mysql 5.6 and mysql 8 on CentOS7. as generally I have practice of installing older version first and than the newer version needs to be installed but while doing so it automatically upgrade the old version and mysql 5.6 becomes mysql 8.

I have tried revers way installed mysql 8 first and tried installing 5.6 than it starts giving conflict error.

I have tried installing the same via rpm packages too but happening the same.

Can any one help me out with this. as i want to run two different mysql on my server, please let me know else let me know what is the proper way to do so if I am doing any thing wrong.

Thanks.
You could do the following if you really need 2 different mysql versions on the same box:

Download the precompiled binaries of the versions you want from here.
Extract them in two different directories and follow the instructions in the tarballs in order to run the servers.

Mind that you cannot share the same databases because the tables structure is not the same across different versions and of course you need to use different ports/sockets if you want to run both servers simultaneously.


Regards
 
Old 08-23-2019, 05:25 AM   #3
dushyantg
Member
 
Registered: Jun 2016
Posts: 70

Original Poster
Rep: Reputation: Disabled
Thank bathory

I have already checked the url which you have shared but its not having any binary file the tar which is available on the shared url is also having bundle of rpm. there is no file of installer with .bin extension there.

What could be the solution in that case.

Is there any other possible way?
 
Old 08-23-2019, 06:00 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,163
Blog Entries: 1

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
Quote:
Originally Posted by dushyantg View Post
Thank bathory

I have already checked the url which you have shared but its not having any binary file the tar which is available on the shared url is also having bundle of rpm. there is no file of installer with .bin extension there.

What could be the solution in that case.

Is there any other possible way?
The archives on that link contain precompiled binaries, meaning that you extract them in some place and mysql is ready to run.

For example click the "Download" button next to the version you want and then click "No thanks, just start my download."
Extract the downloaded archive and follow the instructions. (You maybe don't have to do all the steps, like creating mysql user/group if they already exist)

When finished you can use either one of the following ways to start the server:
Code:
/path/to/mysql-x.y.z/support-files/mysql.server start
/path/to/mysql-x.y.z/bin/mysqld_safe --user=mysql &
 
1 members found this post helpful.
Old 08-23-2019, 06:06 AM   #5
dc.901
Senior Member
 
Registered: Aug 2018
Location: Atlanta, GA - USA
Distribution: CentOS/RHEL, openSuSE/SLES, Ubuntu
Posts: 1,005

Rep: Reputation: 370Reputation: 370Reputation: 370Reputation: 370
One of the many options is you can use docker... You can download different versions of mysql from docker hub.
 
  


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
Any problem if I install CENTOS7 Workstation over CENTOS7 Server? Rich Strebendt Linux - Software 5 05-03-2018 11:05 PM
[SOLVED] Installing two different dsitros on two different HDDs faizlo Linux - Software 3 04-20-2012 07:21 PM
MySql ERROR 1045 (00000): Access denied - different MySQL versions paulsm4 Linux - Software 1 03-01-2011 09:27 PM
can i install two or more intel compilers with different versions on same system?? sonu kumar Linux - Newbie 3 01-17-2010 04:37 AM
Two different Harddrive two different Os tonyr321 Fedora 1 04-01-2005 02:55 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:25 PM.

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