MySQL を 5.5.0 以降にアップグレードしてください

MySQL on FreeBSD

CONTENTS

MySQL を 5.5.0 以降にアップグレードしてください 2015年8月17日
# mysql_upgrade -u root -p

Lastmodified　2015-08-19 (水) 12:47:58

MySQL を 5.5.0 以降にアップグレードしてください 2015年8月17日†

portupgrade したphpMyAdminにアクセスしたらエラー。MySQLは5.1でした。

ということで、取り敢えず　phpMyAdmin-4.0.10.10-all-languages.tar.gz　を取ってきて、解凍インストール。

と同時に、5.1から5.5以上にUPするテスト。

↑

# mysql_upgrade -u root -p†

↑

# portinstall databases/mysql51-client†

↑

# portinstall databases/mysql51-server†

Creating group 'mysql' with gid '88'.
Creating user 'mysql' with uid '88'.
pw: user 'mysql' disappeared during update
************************************************************************

Remember to run mysql_upgrade (with the optional --datadir=<dbdir> flag)
the first time you start the MySQL server after an upgrade from an
earlier version.

************************************************************************

===> SECURITY REPORT:
      This port has installed the following files which may act as network
      servers and may therefore pose a remote security risk to the system.
/usr/local/libexec/mysqld

      This port has installed the following startup scripts which may cause
      these network services to be started at boot time.
/usr/local/etc/rc.d/mysql-server 

      If there are vulnerabilities in these programs there may be a security
      risk to the system. FreeBSD makes no guarantee about the security of
      ports included in the Ports Collection. Please type 'make deinstall'
      to deinstall the port if this is a concern.

      For more information, and contact details about the security
      status of this software, see the following webpage:
http://www.mysql.com/
===>  Cleaning for mysql51-server-5.1.73_2

↑

/usr/local/etc/my.cnf†

コピーして移す

↑

/etc/rc.conf†

mysql_enable="YES"
mysql_dbdir="MySQLデータベースディレクトリのフルパス"

書き込む。

↑

MySQL db をコピー†

# /usr/local/etc/rc.d/mysql-server start
Starting mysql.
su: unknown login: mysql
/usr/local/etc/rc.d/mysql-server: WARNING: failed to start mysql

なんか、初めて見るエラー？？？　http://www.administration-systeme.com/freebsd-apache-mysql-et-php/

# pwd_mkdb -p /etc/master.passwd
# vipw でmysqlの追加を確認

↑

portinstall lang/php5†

↑

portinstall lang/php5-extensions†

# php -v
Created directory: /var/net-snmp
Created directory: /var/net-snmp/mib_indexes
PHP 5.4.44 (cli) (built: Aug 18 2015 13:17:42)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

↑