Howto use mysql-5.7 on Xenial

Environments Xenial
1

I switched to dist: xenial under https://travis-ci.org/ngiger/elexis-3-core/branches
in th branch f11106 as I want to have

  • postgres 9.5
  • jdk8
  • mysql 5.7

However /usr/bin/mysql --version reports
mysql Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using EditLine wrapper

dpkg -l “mysql”| grep ii however lists the expected
ii mysql-client-5.7 5.7.24-0ubuntu0.16.04.1 amd64 MySQL database client binaries

What is the problem here.

2

What is the question? mysql --version reports 5.7.24, right? Is it not what you want?

https://travis-ci.org/BanzaiMan/travis_production_test/builds/455522403#L486-L495

$ mysql -e 'SHOW VARIABLES LIKE "%version%";'
Variable_name	Value
innodb_version	5.7.24
protocol_version	10
slave_type_conversions	
tls_version	TLSv1,TLSv1.1
version	5.7.24-0ubuntu0.16.04.1
version_comment	(Ubuntu)
version_compile_machine	x86_64
version_compile_os	Linux
3

See https://travis-ci.org/ngiger/elexis-3-core/builds/455501549 I got
$ /usr/bin/mysql --version
/usr/bin/mysql Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using EditLine wrapper

4

I think that’s the right output for the version 5.7.24 client. With 5.6, you’d get

$ mysql -V
mysql  Ver 14.14 Distrib 5.6.33, for debian-linux-gnu (x86_64) using  EditLine wrapper
5

Sorry for the noise. I just didn’t examine the result close enough and got puzzled as psql reports the version a little bit different.

Thanks for your help