DEV Community

Patrick Schanen
Patrick Schanen

Posted on

2

Linux CentOS7 update mysql 5.5 to 5.6 for Magento 2.2.3

[root@magento-server localhost]# ll
total 1076
drwxrwxrwx.  4 root   root      110 Apr 22 17:50 app
-rwxrwxrwx.  1 root   root      138 Apr 22 17:49 auth.json.sample
drwxrwxrwx.  2 root   root       38 Apr 22 17:50 bin
-rwxrwxrwx.  1 root   root   566648 Apr 22 17:49 CHANGELOG.md
-rwxrwxrwx.  1 root   root     1921 Apr 22 21:22 composer.json
-rwxrwxrwx.  1 root   root   443259 Apr 22 17:49 composer.lock
-rwxrwxrwx.  1 root   root     3671 Apr 22 17:49 CONTRIBUTING.md
-rwxrwxrwx.  1 root   root      647 Apr 22 17:49 COPYING.txt
drwxrwxrwx.  5 root   root       63 Apr 22 17:50 dev
drwxrwxrwx.  3 root   root       35 Apr 22 21:25 generated
-rwxrwxrwx.  1 root   root       57 Apr 22 17:49 grunt-config.json.sample
-rwxrwxrwx.  1 root   root     2994 Apr 22 17:49 Gruntfile.js.sample
-rwxrwxrwx.  1 root   root     1370 Apr 22 17:49 index.php
-rwxrwxrwx.  1 root   root      691 Apr 22 17:49 ISSUE_TEMPLATE.md
drwxrwxrwx.  4 root   root       50 Apr 22 17:51 lib
-rwxrwxrwx.  1 root   root    10376 Apr 22 17:49 LICENSE_AFL.txt
-rwxrwxrwx.  1 root   root    10364 Apr 22 17:49 LICENSE.txt
drwxr-xr-x. 14 apache apache   4096 Apr 22 21:08 magento2
-rwxrwxrwx.  1 root   root     5531 Apr 22 17:49 nginx.conf.sample
-rwxrwxrwx.  1 root   root     1415 Apr 22 17:49 package.json.sample
-rwxrwxrwx.  1 root   root      804 Apr 22 17:49 php.ini.sample
drwxrwxrwx.  2 root   root       58 Apr 22 17:51 phpserver
drwxrwxrwx.  6 root   root      182 Apr 22 17:51 pub
-rwxrwxrwx.  1 root   root      804 Apr 22 17:49 PULL_REQUEST_TEMPLATE.md
drwxrwxrwx.  7 root   root      115 Apr 22 17:51 setup
drwxr-xr-x.  2 root   root        6 Apr 22 21:08 test
drwxrwxrwx.  7 root   root      191 Apr 22 17:51 update
drwxrwxrwx.  5 root   root       75 Apr 22 21:25 var
drwxrwxrwx. 42 root   root     4096 Apr 22 21:22 vendor
[root@magento-server localhost]# cd
[root@magento-server ~]# cd /tmp/
[root@magento-server tmp]# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
--2018-04-22 21:29:40--  http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 23.57.81.191
Connecting to repo.mysql.com (repo.mysql.com)|23.57.81.191|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5824 (5.7K) [application/x-redhat-package-manager]
Saving to: ‘mysql-community-release-el6-5.noarch.rpm’

100%[====================================================================================================================>] 5,824       --.-K/s   in 0s      

2018-04-22 21:29:40 (243 MB/s) - ‘mysql-community-release-el6-5.noarch.rpm’ saved [5824/5824]

[root@magento-server tmp]# rpm -ivh mysql-community-release-el6-5.noarch.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-release-el6-5    ################################# [100%]
[root@magento-server tmp]# yum install mysql-server
Loaded plugins: fastestmirror
mysql-connectors-community                                                                                                             | 2.5 kB  00:00:00     
mysql-tools-community                                                                                                                  | 2.5 kB  00:00:00     
mysql56-community                                                                                                                      | 2.5 kB  00:00:00     
(1/3): mysql-connectors-community/x86_64/primary_db                                                                                    |  20 kB  00:00:00     
(2/3): mysql-tools-community/x86_64/primary_db                                                                                         |  41 kB  00:00:00     
(3/3): mysql56-community/x86_64/primary_db                                                                                             | 219 kB  00:00:00     
Loading mirror speeds from cached hostfile
 * base: artfiles.org
 * epel: epel.besthosting.ua
 * extras: centos.mirror.root.lu
 * remi-php71: fr2.rpmfind.net
 * remi-safe: fr2.rpmfind.net
 * updates: artfiles.org
Resolving Dependencies
--> Running transaction check
--------> Package mariadb-server.x86_64 1:5.5.56-2.el7 will be obsoleted
--------> Package mysql-community-server.x86_64 0:5.6.40-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.40-2.el6 for package: mysql-community-server-5.6.40-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.40-2.el6.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-5.6.40-2.el6.x86_64
--> Running transaction check
--------> Package mariadb.x86_64 1:5.5.56-2.el7 will be obsoleted
--------> Package mysql-community-client.x86_64 0:5.6.40-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.40-2.el6.x86_64
--------> Package mysql-community-common.x86_64 0:5.6.40-2.el6 will be installed
--------> Package net-tools.x86_64 0:2.0-0.22.20131004git.el7 will be installed
--> Running transaction check
--------> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
--------> Package mysql-community-libs.x86_64 0:5.6.40-2.el6 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================
 Package                                   Arch                      Version                                       Repository                            Size
==============================================================================================================================================================
Installing:
 mysql-community-client                    x86_64                    5.6.40-2.el6                                  mysql56-community                     18 M
     replacing  mariadb.x86_64 1:5.5.56-2.el7
 mysql-community-libs                      x86_64                    5.6.40-2.el6                                  mysql56-community                    1.9 M
     replacing  mariadb-libs.x86_64 1:5.5.56-2.el7
 mysql-community-server                    x86_64                    5.6.40-2.el6                                  mysql56-community                     55 M
     replacing  mariadb-server.x86_64 1:5.5.56-2.el7
Installing for dependencies:
 mysql-community-common                    x86_64                    5.6.40-2.el6                                  mysql56-community                    308 k
 net-tools                                 x86_64                    2.0-0.22.20131004git.el7                      base                                 305 k

Transaction Summary
==============================================================================================================================================================
Install  3 Packages (+2 Dependent packages)

Total download size: 75 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.40-2.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-5.6.40-2.el6.x86_64.rpm is not installed
(1/5): mysql-community-common-5.6.40-2.el6.x86_64.rpm                                                                                  | 308 kB  00:00:00     
(2/5): mysql-community-libs-5.6.40-2.el6.x86_64.rpm                                                                                    | 1.9 MB  00:00:00     
(3/5): net-tools-2.0-0.22.20131004git.el7.x86_64.rpm                                                                                   | 305 kB  00:00:00     
(4/5): mysql-community-client-5.6.40-2.el6.x86_64.rpm                                                                                  |  18 MB  00:00:11     
(5/5): mysql-community-server-5.6.40-2.el6.x86_64.rpm                                                                                  |  55 MB  00:00:18     
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                         3.8 MB/s |  75 MB  00:00:19     
Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package    : mysql-community-release-el6-5.noarch (installed)
 From       : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Installing : mysql-community-common-5.6.40-2.el6.x86_64                                                                                                 1/8 
  Installing : mysql-community-libs-5.6.40-2.el6.x86_64                                                                                                   2/8 
  Installing : mysql-community-client-5.6.40-2.el6.x86_64                                                                                                 3/8 
  Installing : net-tools-2.0-0.22.20131004git.el7.x86_64                                                                                                  4/8 
  Installing : mysql-community-server-5.6.40-2.el6.x86_64                                                                                                 5/8 
  Erasing    : 1:mariadb-server-5.5.56-2.el7.x86_64                                                                                                       6/8 
warning: /var/log/mariadb/mariadb.log saved as /var/log/mariadb/mariadb.log.rpmsave
  Erasing    : 1:mariadb-5.5.56-2.el7.x86_64                                                                                                              7/8 
  Erasing    : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                                         8/8 
  Verifying  : mysql-community-libs-5.6.40-2.el6.x86_64                                                                                                   1/8 
  Verifying  : mysql-community-server-5.6.40-2.el6.x86_64                                                                                                 2/8 
  Verifying  : mysql-community-client-5.6.40-2.el6.x86_64                                                                                                 3/8 
  Verifying  : net-tools-2.0-0.22.20131004git.el7.x86_64                                                                                                  4/8 
  Verifying  : mysql-community-common-5.6.40-2.el6.x86_64                                                                                                 5/8 
  Verifying  : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                                         6/8 
  Verifying  : 1:mariadb-server-5.5.56-2.el7.x86_64                                                                                                       7/8 
  Verifying  : 1:mariadb-5.5.56-2.el7.x86_64                                                                                                              8/8 

Installed:
  mysql-community-client.x86_64 0:5.6.40-2.el6         mysql-community-libs.x86_64 0:5.6.40-2.el6         mysql-community-server.x86_64 0:5.6.40-2.el6        

Dependency Installed:
  mysql-community-common.x86_64 0:5.6.40-2.el6                                   net-tools.x86_64 0:2.0-0.22.20131004git.el7                                  

Replaced:
  mariadb.x86_64 1:5.5.56-2.el7                   mariadb-libs.x86_64 1:5.5.56-2.el7                   mariadb-server.x86_64 1:5.5.56-2.el7                  

Complete!
[root@magento-server tmp]# /etc/init.d/mysqld start
Starting mysqld (via systemctl):                           [  OK  ]
[root@magento-server tmp]# 
Enter fullscreen mode Exit fullscreen mode

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs