Updating MySQL with Repo?

SUSE Product Topics SLES Updates
1

Hello All,

Operating System: SLES 11 SP3# cat /etc/*release LSB_VERSION="core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64" SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 3

We have this SLES server running as a Webserver with WordPress 4.4 installed on it. The WordPress documentation says it recommends PHP 5.6 and MySQL 5.6.

I have already found a Repo (*and updated the package already) that contained the PHP update, located at the link below. And luckily, because of that, i was able to use the YaST Package Manager to update PHP to 5.6, which has been working just fine since I ran the update a few days ago.

http://download.opensuse.org/repositories/server:/php/SLE_11_SP2/

Now, I am trying to update MySQL from:

[CODE]# mysql --version
mysql Ver 14.14 Distrib 5.5.46, for Linux (x86_64) using readline 5.2

rpm -qa | grep -i mysql

mysql-client-5.5.46-0.14.1
php5-mysql-5.6.9-289.1
mysql-5.5.46-0.14.1
libqt4-sql-mysql-4.6.3-5.34.2
libmysqlclient_r15-5.0.96-0.8.8.1[/CODE]

To MySQL 5.6… And I was hoping someone would be able to point me in the right direction for which Repo I could use in order to update all of my MySQL packages and sub-packages. A co-worker said he updated MySQL on another SLES server not too long ago and he said he did it manually with an RPM and it automatically overwrote the current MySQL version… Is that true, would MySQL installation overwrite an existing installation, using rpm?

However, If I can help it, I’d rather find a Repo containing the Update, but don’t think I have been able to find the correct one just yet…

Does anyone know what Repo I could use to accomplish this…? Any thoughts or suggestions would be greatly appreciated!

Thanks in Advance,
Matt

2

mmartin0926,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

These forums are peer-to-peer, best effort, volunteer run and that if your issue
is urgent or not getting a response, you might try one of the following options:

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.suse.com/faq.php

If this is a reply to a duplicate posting or otherwise posted in error, please
ignore and accept our apologies and rest assured we will issue a stern reprimand
to our posting bot…

Good luck!

Your SUSE Forums Team
http://forums.suse.com

3

On 08/01/2016 20:34, mmartin0926 wrote:
[color=blue]

Operating System: SLES 11 SP3
Code:

 # cat /etc/*release

LSB_VERSION=“core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64”
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 3

We have this SLES server running as a Webserver with WordPress 4.4
installed on it. The WordPress documentation says it recommends PHP 5.6
and MySQL 5.6.

I have already found a Repo (*and updated the package already) that
contained the PHP update, located at the link below. And luckily,
because of that, i was able to use the YaST Package Manager to update
PHP to 5.6, which has been working just fine since I ran the update a
few days ago.

Code:

 [url]http://download.opensuse.org/repositories/server:/php/SLE_11_SP2/[/url]

Now, I am trying to update MySQL from:

Code:

 # mysql --version

mysql Ver 14.14 Distrib 5.5.46, for Linux (x86_64) using readline 5.2

rpm -qa | grep -i mysql

mysql-client-5.5.46-0.14.1
php5-mysql-5.6.9-289.1
mysql-5.5.46-0.14.1
libqt4-sql-mysql-4.6.3-5.34.2
libmysqlclient_r15-5.0.96-0.8.8.1

To -MySQL 5.6-… And I was hoping someone would be able to point me
in the right direction for which Repo I could use in order to update all
of my MySQL packages and sub-packages. A co-worker said he updated MySQL
on another SLES server not too long ago and he said he did it manually
with an RPM and it automatically overwrote the current MySQL version…
Is that true, would MySQL installation overwrite an existing
installation, using rpm?

However, If I can help it, I’d rather find a Repo containing the Update,
but don’t think I have been able to find the correct one just yet…

Does anyone know what Repo I could use to accomplish this…? Any
thoughts or suggestions would be greatly appreciated![/color]

The first thing to note is that SUSE don’t offer either PHP 5.6 or MySQL
5.6 for SLES11 SP3. The latest versions of those packages that SUSE
provide are 5.3 and 5.5 respectively.

The later version of PHP 5.6 you have found is provided by the openSUSE
Build Service and so not supported by SUSE … which therefore starts to
negate your use of SLES as a SUSE-supported Enterprise product.

I also notice that you’re using SLES11 SP3 for which General Support has
now ended in favour of SLES11 SP4. However SLES11 SP4 also offers the
same versions of PHP and MySQL as SLES11 SP3.

SLES12 offers PHP 5.5 but MySQL is replaced by MariaDB.

I note that whilst WordPress recommend PHP 5.6+ and MySQL 5.6+ they say
WordPress also works with PHP 5.2.4+ and MySQL 5.0+ so it should work
with SLES11 SP3 (though you ought to upgrade to SLES11 SP4 for support).

If official SUSE support is not an issue for you then you can use later
versions of PHP and MySQL available from the openSUSE Build Service
though I’d suggest that you might actually be better off switching to
using openSUSE Leap or Tumbleweed which would offer later versions of
packages.

HTH.

Simon
SUSE Knowledge Partner

If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below. Thanks.

4

I was able to get MySQL 5.6 installed successfully using the MySQL repo at repo.mysql.com.

# mysql --version mysql Ver 14.14 Distrib 5.6.28, for Linux (x86_64) using EditLine wrapper

You can download the RPM containing the MySQL Repos for SLES 11 on this page below. They have a repo for SLES 11 and SLES 12. I used the one for 11 since I’m running 11.4 and it seems to have worked.
[INDENT]https://dev.mysql.com/downloads/repo/suse/[/INDENT]

I also had to start mysql, service mysql start and then I had to run the command mysql_upgrade to make sure MySQL updated properly. And it seems to have run successfully.

-Matt