Score:0

mysql -V shows a different version than mysqld -V

cn flag

I'm running centos 7 with mySQL 5.7.xxx. mysql -V shows Ver 14.14 Distrib 5.7.26-29, but mysqld -V shows Ver 5.7.11-4. systemctl status mysql and systemctl status mysqld both show the same running database. SELECT @@version in the client shows 5.7.11-4-log. The database acts like it is running the previous version (some differences in JSON functions, for instance).

Some background: when we started using JSON functions I attempted to update the database to the latest 5.7 version (on my way to updating to 8 preferably), but it didn't seem to work so I tabled it until I had more time. I'm not really sure what to do next. I don't know if this is a server problem or a database problem, or how to troubleshoot or proceed.

Sorry I can't provide more information, but I'm not really sure what I'm looking for. I can backup the database and uninstall mysql completely if there's not a better way to go about it, just not sure what to do, and I also remember reading that you should update your database in place and not skip a major version on the way (ie, 5.5->5.6->5.7->8.0) but I don't know if that's true or not.

asktyagi avatar
in flag
It's server vs client, mysqld is server and mysql is client.
Chris Strickland avatar
cn flag
@asktyagi I asked this on dba.stackexchange also and someone commented the same thing there. The issue was that the two versions were misaligned. Not sure how, and I didn't know you could update one without the other. Just knowing this piece of information was enough to solve the problem. If you want to write this into an answer I'll accept it.
Score:0
in flag

You will mostly see difference between server and client software, in your case it's mysql server vs mysql client, mysqld is server and mysql is client.

Which version you should use listed here based on client features: https://downloads.mysql.com/docs/mysql-compat-matrix-en.pdf see Compatibility Between MySQL Servers and MySQL Clients/Tools section. If you are using bit old version you have search in doc for further details.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.