• Registered: 2011-05-19
  • Posts: 19

Topic: Distribution for MySQL 5.5.12 shows server version 5.0.77

I am trying to install MySQL 5.1 in my CentOS 5.6.  Please see this post at the CentOS forum for my efforts in this area.

https://www.centos.org/modules/newbb/vi … p;forum=41

What does it mean when I look at MySQL using the mysql client and using \s to find out the server status, I see:

mysql  Ver 14.14 Distrib 5.5.12, for Linux (i686) using readline 5.1

Connection id:          2
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.77
....

For a server version, I was hoping to see 5.1.XX or better.  Seeing 5.5.12 in the distribution suggested to me I was getting a server version 5.5.XX.

What is going on?  I uninstalled the old mysql using the Package Manger from the graphic user interface.  And I also enabled the repo and installed from the same Package Manager.  What, if anything, did I miss?

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,839

Re: Distribution for MySQL 5.5.12 shows server version 5.0.77

What does return

rpm -qa | grep -i mysql
which mysql
Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,839

Re: Distribution for MySQL 5.5.12 shows server version 5.0.77

When I ask version, I have:

# mysql -pxxxxx -e "show variables like '%version%'"
+-------------------------+--------------------------------------+
| Variable_name           | Value                                |
+-------------------------+--------------------------------------+
| innodb_version          | 1.1.6                                |
| protocol_version        | 10                                   |
| slave_type_conversions  |                                      |
| version                 | 5.5.12                               |
| version_comment         | MySQL Community Server (GPL) by Remi |
| version_compile_machine | x86_64                               |
| version_compile_os      | Linux                                |
+-------------------------+--------------------------------------+
Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-05-19
  • Posts: 19

Re: Distribution for MySQL 5.5.12 shows server version 5.0.77

I seem to have resolved the problem.

I shut down the server from the desktop, I then went into the command line terminal and used,

yum groupremove mysql

After that was done, I applied

yum groupinstall mysql

I can no go into the mysql client and get the right server version, 5.5.12.

I'm not sure what the problem was, but I consider solved at this point.  I picked up some clues browsing the yum commands by just typing "yum" in the command window.  There is also, 

yum groupinfo mysql

Many thanks to Remi for the opportunity to upgrade my MySQL server.

5 Reply by William Brown (edited by William Brown 2011-06-12 17:15:09)

  • Registered: 2011-06-10
  • Posts: 2

Re: Distribution for MySQL 5.5.12 shows server version 5.0.77

My SQL client get the opportunity and get the right server version. wink

Vancouver Vacation Rental