I have two machines, one local (mine) and one server... both of them have MySQL installed, but for some reason they use different MySQL versions, although the installation process was exactly the same.
When I run mysql --version
in my machine I see:
mysql Ver 8.0.18-0ubuntu0.19.10.1 for Linux on x86_64 ((Ubuntu))
But in my server I see:
mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper
Because they are different, I can't restore the dump of one into the other. Would it be possible to specify a version when installing mysql?
Thank you.
mysql --version
is only showing the client version. To look at the server version connect andSELECT VERSION()