感想
状態:-
閲覧数:2,042
投稿日:2016-02-13
更新日:2018-03-27
最初に書いとくよ
・このページ書いた人、神過ぎるわ!
・MAMPでpdoが動きません>< "could not find driver" とか出てます
phpinfo()
PDO
php.iniの設定を変更し、反映させる
PDO
・「yumコマンドで既にインストールしたパッケージリスト」を検索
MySQL5.5を5.6へアップグレードしようとしたらエラー
・MySQL5.5から、5.6にバージョンアップ
・CentOSのMySQLを5.5から5.6にアップデートする
・このページ書いた人、神過ぎるわ!
・MAMPでpdoが動きません>< "could not find driver" とか出てます
phpinfo()
<?php phpinfo(); ?>
Loaded Configuration File | /etc/php.ini |
---|
PDO support | enabled |
---|---|
PDO drivers | sqlite |
Directive | Local Value | Master Value |
---|---|---|
extension_dir | /usr/lib64/php/modules | /usr/lib64/php/modules |
# vi /etc/php.ini
▼etc/php.ini; extension_dir = "./"
extension_dir = "/usr/lib64/php/modules";
extension=imagick.so
php.iniの設定を変更し、反映させる
/etc/init.d/httpd restart
PDO
PDO support | enabled |
---|---|
PDO drivers | mysql, sqlite |
サーバー エラー
500
500
・「yumコマンドで既にインストールしたパッケージリスト」を検索
# yum list installed | grep php
graphviz-lang-php.x86_64 2.38.0-1.el6 @graphviz-stable
php.x86_64 5.4.32-1.el6.remi @remi
php-cli.x86_64 5.4.32-1.el6.remi @remi
php-common.x86_64 5.4.32-1.el6.remi @remi
php-devel.x86_64 5.4.32-1.el6.remi @remi
php-gd.x86_64 5.4.32-1.el6.remi @remi
php-mbstring.x86_64 5.4.32-1.el6.remi @remi
php-mcrypt.x86_64 5.4.32-1.el6.remi @remi
php-mysql.x86_64 5.4.32-1.el6.remi @remi
php-pdo.x86_64 5.4.32-1.el6.remi @remi
php-pear.noarch 1:1.9.4-4.el6 @base
php-php-gettext.noarch 1.0.11-3.el6 @epel
php-xml.x86_64 5.4.32-1.el6.remi @remi
phpMyAdmin.noarch 3.5.8.2-1.el6 @epel
# rpm -qa | grep mysql
mysql-libs-5.5.39-1.el6.remi.x86_64
mysql-server-5.5.39-1.el6.remi.x86_64
mysql-5.5.39-1.el6.remi.x86_64
php-mysql-5.4.32-1.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-community-release-el6-5.noarch
MySQL5.5を5.6へアップグレードしようとしたらエラー
・MySQL5.5から、5.6にバージョンアップ
・CentOSのMySQLを5.5から5.6にアップデートする
1回目失敗 / 依存性エラー発生
1.MySQLデータバックアップ
緊急時リカバリ用
・最終的に成功したため、今回は利用しなかった
# mysqldump -u 全データベース共通ユーザ名 -p --all-databases > /var/www/lib/dbbackup_`date +%Y%m%d%H%M%S`.sql
Enter password:
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
・MySQL5.5.39 バックアップ
2.リポジトリ取得
# rpm -ivh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm を取得中
準備中... ########################################### [100%]
1:mysql-community-release########################################### [100%]
内容確認
# cat /etc/yum.repos.d/mysql-community.repo
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Enable to use MySQL 5.5
[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Note: MySQL 5.7 is currently in development. For use at your own risk.
# Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/
[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
3.MySQLサービス停止
# /etc/init.d/mysqld stop
mysqld を停止中: [ OK ]
4.mysql-serverをyumで update
# yum update mysql-server
依存性エラー発生Loaded plugins: fastestmirror, security
Determining fastest mirrors
epel/metalink | 5.8 kB 00:00
* base: ftp.nara.wide.ad.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.nara.wide.ad.jp
* rpmforge: mirror.fairway.ne.jp
* updates: ftp.nara.wide.ad.jp
10gen | 951 B 00:00
base | 3.7 kB 00:00
epel | 4.3 kB 00:00
epel/primary_db | 5.8 MB 00:00
extras | 3.4 kB 00:00
http://www.graphviz.org/pub/graphviz/stable/redhat/el6/x86_64/os/repodata/repomd.xml: [Errno 12] Timeout on http://www.graphviz.org/pub/graphviz/stable/redhat/el6/x86_64/os/repodata/repomd.xml: (28, 'connect() timed out!')
Trying other mirror.
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db | 8.7 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql-tools-community/primary_db | 27 kB 00:00
mysql56-community | 2.5 kB 00:00
mysql56-community/primary_db | 125 kB 00:00
rpmforge | 1.9 kB 00:00
updates | 3.4 kB 00:00
updates/primary_db | 3.9 MB 00:00
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.29-2.el6 for package: mysql-community-client-5.6.29-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.29-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.29-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.32-1.el6.remi.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysql-5.4.32-1.el6.remi.x86_64 (@remi)
Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.5.39-1.el6.remi.x86_64 (@remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-5.6.29-2.el6.x86_64 (mysql56-community)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
5.MySQLサービス起動
# /etc/init.d/mysqld start
mysqld を起動中:
6.MySQLバージョン確認
# mysql --version
途中でエラーが発生したため、アップデートされていないmysql Ver 14.14 Distrib 5.5.39, for Linux (x86_64) using readline 5.1
2回目失敗 / # yum update --skip-broken mysql-server
4.--skip-brokenオプションを付与してmysql-serverをyumで update
依存性に問題があるパッケージをスキップ処理
# yum update --skip-broken mysql-serverLoaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.nara.wide.ad.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.nara.wide.ad.jp
* rpmforge: mirror.fairway.ne.jp
* updates: ftp.nara.wide.ad.jp
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.29-2.el6 for package: mysql-community-client-5.6.29-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.29-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.29-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.32-1.el6.remi.x86_64
mysql56-community/filelists_db | 350 kB 00:00
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.29-2.el6 for package: mysql-community-client-5.6.29-2.el6.x86_64
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
Packages skipped because of dependency problems:
mysql-community-client-5.6.29-2.el6.x86_64 from mysql56-community
mysql-community-common-5.6.29-2.el6.x86_64 from mysql56-community
mysql-community-libs-5.6.29-2.el6.x86_64 from mysql56-community
mysql-community-server-5.6.29-2.el6.x86_64 from mysql56-community
5.MySQLサービス起動
# /etc/init.d/mysqld start
mysqld を起動中:
6.MySQLバージョン確認
# mysql --version
依存性に問題があるパッケージをスキップ処理したため、アップデートされていないmysql Ver 14.14 Distrib 5.5.39, for Linux (x86_64) using readline 5.1
3回目失敗 / yum clean all 後、yum update
# yum clean all
Loaded plugins: fastestmirror, security
Cleaning repos: 10gen base epel extras graphviz-stable mysql-connectors-community mysql-tools-community mysql56-community
: rpmforge updates
Cleaning up Everything
Cleaning up list of fastest mirrors
# yum update
Loaded plugins: fastestmirror, security
Determining fastest mirrors
epel/metalink | 6.2 kB 00:00
* base: ftp.nara.wide.ad.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.nara.wide.ad.jp
* rpmforge: mirror.fairway.ne.jp
* updates: ftp.nara.wide.ad.jp
10gen | 951 B 00:00
10gen/primary | 44 kB 00:00
10gen 274/274
base | 3.7 kB 00:00
//中略
---> Package pygobject2.x86_64 0:2.20.0-5.el6 will be installed
--> Running transaction check
---> Package dejavu-fonts-common.noarch 0:2.33-1.el6 will be installed
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.32-1.el6.remi.x86_64
---> Package php-bcmath.x86_64 0:5.3.3-46.el6_7.1 will be installed
--> Processing Dependency: php-common(x86-64) = 5.3.3-46.el6_7.1 for package: php-bcmath-5.3.3-46.el6_7.1.x86_64
---> Package php-process.x86_64 0:5.3.3-46.el6_7.1 will be installed
--> Processing Dependency: php-common(x86-64) = 5.3.3-46.el6_7.1 for package: php-process-5.3.3-46.el6_7.1.x86_64
---> Package php-tidy.x86_64 0:5.3.3-46.el6_7.1 will be installed
--> Processing Dependency: php-common(x86-64) = 5.3.3-46.el6_7.1 for package: php-tidy-5.3.3-46.el6_7.1.x86_64
10gen/filelists | 9.9 kB 00:00
base/filelists_db | 6.3 MB 00:00
epel/filelists_db | 8.0 MB 00:00
extras/filelists_db | 37 kB 00:00
mysql-connectors-community/filelists_db | 6.1 kB 00:00
mysql-tools-community/filelists_db | 67 kB 00:00
mysql56-community/filelists_db | 350 kB 00:00
rpmforge/filelists_db | 2.3 MB 00:02
updates/filelists_db | 3.1 MB 00:00
--> Finished Dependency Resolution
Error: Package: php-tidy-5.3.3-46.el6_7.1.x86_64 (updates)
Requires: php-common(x86-64) = 5.3.3-46.el6_7.1
Installed: php-common-5.4.32-1.el6.remi.x86_64 (@remi)
php-common(x86-64) = 5.4.32-1.el6.remi
Available: php-common-5.3.3-40.el6_6.x86_64 (base)
php-common(x86-64) = 5.3.3-40.el6_6
Available: php-common-5.3.3-46.el6_6.x86_64 (updates)
php-common(x86-64) = 5.3.3-46.el6_6
Available: php-common-5.3.3-46.el6_7.1.x86_64 (updates)
php-common(x86-64) = 5.3.3-46.el6_7.1
Error: Package: php-mysql-5.4.32-1.el6.remi.x86_64 (@remi)
Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.5.39-1.el6.remi.x86_64 (@remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-compat-5.6.29-2.el6.x86_64 (mysql56-community)
Not found
Error: Package: php-process-5.3.3-46.el6_7.1.x86_64 (updates)
Requires: php-common(x86-64) = 5.3.3-46.el6_7.1
Installed: php-common-5.4.32-1.el6.remi.x86_64 (@remi)
php-common(x86-64) = 5.4.32-1.el6.remi
Available: php-common-5.3.3-40.el6_6.x86_64 (base)
php-common(x86-64) = 5.3.3-40.el6_6
Available: php-common-5.3.3-46.el6_6.x86_64 (updates)
php-common(x86-64) = 5.3.3-46.el6_6
Available: php-common-5.3.3-46.el6_7.1.x86_64 (updates)
php-common(x86-64) = 5.3.3-46.el6_7.1
Error: Package: php-bcmath-5.3.3-46.el6_7.1.x86_64 (updates)
Requires: php-common(x86-64) = 5.3.3-46.el6_7.1
Installed: php-common-5.4.32-1.el6.remi.x86_64 (@remi)
php-common(x86-64) = 5.4.32-1.el6.remi
Available: php-common-5.3.3-40.el6_6.x86_64 (base)
php-common(x86-64) = 5.3.3-40.el6_6
Available: php-common-5.3.3-46.el6_6.x86_64 (updates)
php-common(x86-64) = 5.3.3-46.el6_6
Available: php-common-5.3.3-46.el6_7.1.x86_64 (updates)
php-common(x86-64) = 5.3.3-46.el6_7.1
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
4回目失敗 / 新規リポジトリ取得先へ変更(したつもり)
# rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
http://rpms.famillecollet.com/enterprise/remi-release-6.rpm を取得中
準備中... ########################################### [100%]
ファイル /etc/yum.repos.d/remi.repo (パッケージ remi-release-6.6-2.el6.remi.noarch から) は、パッケージ remi-release-6.5-1.el6.remi.noarch からのファイルと競合しています。
# rpm -e remi-release-6.5-1.el6.remi.noarch
# rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
http://rpms.famillecollet.com/enterprise/remi-release-6.rpm を取得中
準備中... ########################################### [100%]
1:remi-release ########################################### [100%]
# yum -y update mysql-server mysql-devel
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.nara.wide.ad.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.nara.wide.ad.jp
* remi-safe: remi.kazukioishi.net
* rpmforge: mirror.fairway.ne.jp
* updates: ftp.nara.wide.ad.jp
http://www.graphviz.org/pub/graphviz/stable/redhat/el6/x86_64/os/repodata/repomd.xml: [Errno 12] Timeout on http://www.graphviz.org/pub/graphviz/stable/redhat/el6/x86_64/os/repodata/repomd.xml: (28, 'Operation too slow. Less than 1 bytes/sec transfered the last 30 seconds')
Trying other mirror.
remi-safe | 2.9 kB 00:00
remi-safe/primary_db | 238 kB 00:00
Setting up Update Process
Package(s) mysql-devel available, but not installed.
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.29-2.el6 for package: mysql-community-client-5.6.29-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.29-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.29-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.32-1.el6.remi.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysql-5.4.32-1.el6.remi.x86_64 (@remi)
Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.5.39-1.el6.remi.x86_64 (@remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-5.6.29-2.el6.x86_64 (mysql56-community)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
5回目 / MySQL自体のインストールには成功
# /etc/init.d/mysqld start
mysqld を起動中: [ OK ]
# yum list installed | grep php
graphviz-lang-php.x86_64 2.38.0-1.el6 @graphviz-stable
php.x86_64 5.4.32-1.el6.remi @remi
php-cli.x86_64 5.4.32-1.el6.remi @remi
php-common.x86_64 5.4.32-1.el6.remi @remi
php-devel.x86_64 5.4.32-1.el6.remi @remi
php-gd.x86_64 5.4.32-1.el6.remi @remi
php-mbstring.x86_64 5.4.32-1.el6.remi @remi
php-mcrypt.x86_64 5.4.32-1.el6.remi @remi
php-mysql.x86_64 5.4.32-1.el6.remi @remi
php-pdo.x86_64 5.4.32-1.el6.remi @remi
php-pear.noarch 1:1.9.4-4.el6 @base
php-php-gettext.noarch 1.0.11-3.el6 @epel
php-xml.x86_64 5.4.32-1.el6.remi @remi
phpMyAdmin.noarch 3.5.8.2-1.el6 @epel
# rpm -qa | grep mysql
mysql-libs-5.5.39-1.el6.remi.x86_64
mysql-server-5.5.39-1.el6.remi.x86_64
mysql-5.5.39-1.el6.remi.x86_64
php-mysql-5.4.32-1.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-community-release-el6-5.noarch
# yum erase php-mysql
Loaded plugins: fastestmirror, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.4.32-1.el6.remi will be erased
--> Processing Dependency: php-mysql >= 5.2.0 for package: phpMyAdmin-3.5.8.2-1.el6.noarch
--> Running transaction check
---> Package phpMyAdmin.noarch 0:3.5.8.2-1.el6 will be erased
--> Finished Dependency Resolution
graphviz-stable | 951 B 00:00
graphviz-stable/primary | 28 kB 00:00
Dependencies Resolved
==============================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================
Removing:
php-mysql x86_64 5.4.32-1.el6.remi @remi 452 k
Removing for dependencies:
phpMyAdmin noarch 3.5.8.2-1.el6 @epel 18 M
Transaction Summary
==============================================================================================================================
Remove 2 Package(s)
Installed size: 18 M
Is this ok [y/N]:
y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Erasing : phpMyAdmin-3.5.8.2-1.el6.noarch 1/2
警告: /etc/phpMyAdmin/config.inc.php は /etc/phpMyAdmin/config.inc.php.rpmsave として保存されました。
警告: /etc/httpd/conf.d/phpMyAdmin.conf は /etc/httpd/conf.d/phpMyAdmin.conf.rpmsave として保存されました。
Erasing : php-mysql-5.4.32-1.el6.remi.x86_64 2/2
Verifying : php-mysql-5.4.32-1.el6.remi.x86_64 1/2
Verifying : phpMyAdmin-3.5.8.2-1.el6.noarch 2/2
Removed:
php-mysql.x86_64 0:5.4.32-1.el6.remi
Dependency Removed:
phpMyAdmin.noarch 0:3.5.8.2-1.el6
Complete!
# service mysqld stop
mysqld を停止中: [ OK ]
# yum update mysql-server mysql-devel
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.nara.wide.ad.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.nara.wide.ad.jp
* remi-safe: mirror.innosol.asia
* rpmforge: mirror.fairway.ne.jp
* updates: ftp.nara.wide.ad.jp
graphviz-stable 136/136
Setting up Update Process
Package(s) mysql-devel available, but not installed.
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.6.29-2.el6 for package: mysql-community-server-5.6.29-2.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.29-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.29-2.el6 for package: mysql-community-client-5.6.29-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.29-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.29-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================
Installing:
mysql-community-client x86_64 5.6.29-2.el6 mysql56-community 18 M
replacing mysql.x86_64 5.5.39-1.el6.remi
mysql-community-libs x86_64 5.6.29-2.el6 mysql56-community 1.9 M
replacing mysql-libs.x86_64 5.5.39-1.el6.remi
mysql-community-server x86_64 5.6.29-2.el6 mysql56-community 53 M
replacing mysql-server.x86_64 5.5.39-1.el6.remi
Installing for dependencies:
mysql-community-common x86_64 5.6.29-2.el6 mysql56-community 308 k
Transaction Summary
==============================================================================================================================
Install 4 Package(s)
Total download size: 73 M
Is this ok [y/N]: y
Downloading Packages:
(1/4): mysql-community-client-5.6.29-2.el6.x86_64.rpm | 18 MB 00:01
(2/4): mysql-community-common-5.6.29-2.el6.x86_64.rpm | 308 kB 00:00
(3/4): mysql-community-libs-5.6.29-2.el6.x86_64.rpm | 1.9 MB 00:00
(4/4): mysql-community-server-5.6.29-2.el6.x86_64.rpm | 53 MB 00:04
------------------------------------------------------------------------------------------------------------------------------
Total 11 MB/s | 73 MB 00:06
警告: rpmts_HdrFromFdno: ヘッダ V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
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>
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 rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql-community-common-5.6.29-2.el6.x86_64 1/7
Installing : mysql-community-libs-5.6.29-2.el6.x86_64 2/7
Installing : mysql-community-client-5.6.29-2.el6.x86_64 3/7
Installing : mysql-community-server-5.6.29-2.el6.x86_64 4/7
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Erasing : mysql-server-5.5.39-1.el6.remi.x86_64 5/7
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Erasing : mysql-5.5.39-1.el6.remi.x86_64 6/7
Erasing : mysql-libs-5.5.39-1.el6.remi.x86_64 7/7
Verifying : mysql-community-common-5.6.29-2.el6.x86_64 1/7
Verifying : mysql-community-client-5.6.29-2.el6.x86_64 2/7
Verifying : mysql-community-server-5.6.29-2.el6.x86_64 3/7
Verifying : mysql-community-libs-5.6.29-2.el6.x86_64 4/7
Verifying : mysql-5.5.39-1.el6.remi.x86_64 5/7
Verifying : mysql-libs-5.5.39-1.el6.remi.x86_64 6/7
Verifying : mysql-server-5.5.39-1.el6.remi.x86_64 7/7
Installed:
mysql-community-client.x86_64 0:5.6.29-2.el6 mysql-community-libs.x86_64 0:5.6.29-2.el6
mysql-community-server.x86_64 0:5.6.29-2.el6
Dependency Installed:
mysql-community-common.x86_64 0:5.6.29-2.el6
Replaced:
mysql.x86_64 0:5.5.39-1.el6.remi mysql-libs.x86_64 0:5.5.39-1.el6.remi mysql-server.x86_64 0:5.5.39-1.el6.remi
Complete!
# /etc/init.d/mysqld start
mysqld を起動中: [ OK ]
# mysql --version
mysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine wrapper
後処理
警告: /etc/phpMyAdmin/config.inc.php は /etc/phpMyAdmin/config.inc.php.rpmsave として保存されました。
警告: /etc/httpd/conf.d/phpMyAdmin.conf は /etc/httpd/conf.d/phpMyAdmin.conf.rpmsave として保存されました。
cp -rp /etc/httpd/conf.d/phpMyAdmin.conf.rpmsave /etc/httpd/conf.d/phpMyAdmin.conf
cp -rp /etc/phpMyAdmin/config.inc.php.rpmsave /etc/phpMyAdmin/config.inc.php
php-mysql インストールできない
# rpm -ql phpMyAdmin
パッケージ phpMyAdmin はインストールされていません。
MySQL5.6の PHPドライバ
依存エラー
・
yum erase php-mysql
php-mysqlがインストールができない
php-mysql インストールできない
php-mysqlndを使う
mysql.server: コマンドが見つかりません
・rpmでLinuxにインストールした場合は/etc/init.d/mysqldがmysql.serverに相当する
Package(s) mysql-server available, but not installed
パッケージ削除
mysql5.6の幕開け
Package mysql-server-5.1.73-5.el6_6.x86_64 is obsoleted by mysql-community-server-5.6.29-2.el6.x86_64 which is already installed
yum install -y php-mysql
mysql -u e1blue -p
# service mysql start 「mysql: 認識されていないサービスです。」となります
mv /etc/my.cnf /etc/my.cnf-20160212
# yum --enablerepo=mysql56-community install mysql-community-server
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.nara.wide.ad.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.nara.wide.ad.jp
* remi-safe: mirrors.thzhost.com
* rpmforge: mirror.fairway.ne.jp
* updates: ftp.nara.wide.ad.jp
Setting up Install Process
Package mysql-community-server-5.6.29-2.el6.x86_64 already installed and latest version
Nothing to do
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed
# mysql_upgrade -u root -p
This installation of MySQL is already upgraded to 5.6.29, use --force if you still need to run mysql_upgrade
yum update mysql-server mysql-devel
yum update --skip-broken mysql-server
# yum update mysql-server mysql-devel
http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.11-1.el6.x86_64.rpm
トラブル
MySQL5.5を5.6へアップグレードしようとしたらエラー
http://www.karakaram.com/mysql-yum-update-55-to-56
上記リンク先手順で「# yum update mysql-server」したら、下記エラーとなりました。
--> Finished Dependency Resolution Error: Package: php-mysql-5.4.32-1.el6.remi.x86_64 (@remi)
Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.5.39-1.el6.remi.x86_64 (@remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-5.6.29-2.el6.x86_64 (mysql56-community)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
起動すると、バージョンは5.5のままでした。
質問
・このエラーメッセージはどういう意味でしょうか?
・どうして5.4絡みの依存性が関係するのでしょうか?
・「mysql-libs-5.5.39-1.el6.remi.x86_64」を削除すれば良いのでしょうか?
・それとも、--skip-brokenコマンドを実行すれば良いのでしょうか?
・良く分からないコマンドを打つのは怖いので意味を知りたいです
環境
・CentOS 6.4
MySQL5.5を5.6へアップグレードしようとしたら、500エラー
MySQLを使用していないPHPページは普通に表示
・コマンドでMySQLへログイン可能
・どこを確認すれば良いか分からない
「mysql --version」でバージョン表示されるのに、# service mysql start 「mysql: 認識されていないサービスです」と表示されます
**MySQL5.5を5.6へアップグレードしようとしたら、500エラーになりました**
・MySQLを使用していないPHPページは普通に表示されます
・コマンドでMySQLへログインできます
----------
**質問**
・今、どういう状態なのでしょうか?
----------
**# mysql --version**
> mysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine
> wrapper
----------
**# service mysql start**
> mysql: 認識されていないサービスです。
----------
**# /etc/init.d/mysql start**
> bash: /etc/init.d/mysql: そのようなファイルやディレクトリはありません
----------
**# /etc/init.d/mysqld start**
> mysqld を起動中:
----------
**# which mysql**
> /usr/bin/mysql
----------
**# yum -y install mysql-server**
> Error: Nothing to do
----------
**# yum update mysql-server mysql-devel**
> Package(s) mysql-server available, but not installed.
Package(s) mysql-devel available, but not installed.
No Packages marked for Update
http://www.karakaram.com/mysql-yum-update-55-to-56
上記リンク先手順で「# yum update mysql-server」したら、下記エラーとなりました。
--> Finished Dependency Resolution Error: Package: php-mysql-5.4.32-1.el6.remi.x86_64 (@remi)
Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.5.39-1.el6.remi.x86_64 (@remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-5.6.29-2.el6.x86_64 (mysql56-community)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
起動すると、バージョンは5.5のままでした。
質問
・このエラーメッセージはどういう意味でしょうか?
・どうして5.4絡みの依存性が関係するのでしょうか?
・「mysql-libs-5.5.39-1.el6.remi.x86_64」を削除すれば良いのでしょうか?
・それとも、--skip-brokenコマンドを実行すれば良いのでしょうか?
・良く分からないコマンドを打つのは怖いので意味を知りたいです
環境
・CentOS 6.4
MySQL5.5を5.6へアップグレードしようとしたら、500エラー
MySQLを使用していないPHPページは普通に表示
・コマンドでMySQLへログイン可能
・どこを確認すれば良いか分からない
# mysql --version
mysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine
wrapper
# /etc/init.d/mysqld start
mysqld を起動中:
# which mysql
/usr/bin/mysql
# yum -y install mysql-server
Error: Nothing to do
# yum update mysql-server mysql-devel
Package(s) mysql-server available, but not installed.
Package(s) mysql-devel available, but not installed.
No Packages marked for Update
# mysql_upgrade -u root -p
This installation of MySQL is already upgraded to 5.6.29, use --force
if you still need to run mysql_upgrade
「mysql --version」でバージョン表示されるのに、# service mysql start 「mysql: 認識されていないサービスです」と表示されます
**MySQL5.5を5.6へアップグレードしようとしたら、500エラーになりました**
・MySQLを使用していないPHPページは普通に表示されます
・コマンドでMySQLへログインできます
----------
**質問**
・今、どういう状態なのでしょうか?
----------
**# mysql --version**
> mysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine
> wrapper
----------
**# service mysql start**
> mysql: 認識されていないサービスです。
----------
**# /etc/init.d/mysql start**
> bash: /etc/init.d/mysql: そのようなファイルやディレクトリはありません
----------
**# /etc/init.d/mysqld start**
> mysqld を起動中:
----------
**# which mysql**
> /usr/bin/mysql
----------
**# yum -y install mysql-server**
> Error: Nothing to do
----------
**# yum update mysql-server mysql-devel**
> Package(s) mysql-server available, but not installed.
Package(s) mysql-devel available, but not installed.
No Packages marked for Update