Mysql – Multiple versions of thesql / mariadb

mariadbMySQL

I am running 10.3.18-MariaDB-log MariaDB Server but for one application it require I run mysql 5.7, so I am installed that to run under another port which works fine.

However for the software that requires mysql 5.7 I cannot seem to pass this as my mysql client version still shows up as mariadb's 5.5 mysql client.

This is my.cnf for the mysql 5.7 version

[mysql]

# CLIENT #
port                           = 3307
socket                         = /var/lib/mysql2/mysql2.sock


[mysqld]
port = 3307
socket                         = /var/lib/mysql2/mysql2.sock
datadir = /var/lib/mysql2
pid-file=/var/lib/mysql2/mysqld2.pid

is there someway to specify what mysql client binary I can run ? I am not sure what I am doing wrong?

/usr/local/mysql2/bin/mysql -V
/usr/local/mysql2/bin/mysql  Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using  EditLine wrapper

/usr/local/mysql2/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 99552
Server version: 5.5.5-10.3.18-MariaDB-log MariaDB Server

Best Answer

thanks everyone, lack of experience with multiple versions added to my issues as well assuming that I was running the client of the installed mysql version 5.7 would have me use that version was wrong as it would still load the wrong my.cnf which

/usr/local/mysql2/bin/mysql -u grshop_grpim -p --verbose --help | grep -A 1 "Default options" showed me.

I also think I needed to bind to the 127.0.0.1 instead of localhost but cannot verify that. 

[mysqld]
bind-address           = 127.0.0.1
Related Question