mysql56 to 57
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mysql56 to 57 [#j68ae7e0]
https://freebsd.sing.ne.jp/11.01/09/03.html
[[「MySQL で my.cnf のシンタックスチェックを行う方法」:ht...
/usr/local/libexec/mysqld --verbose --help > /dev/null
**pkg delete mysql56-client-5.6.41 [#xfd49d41]
Installed packages to be REMOVED:
mysql56-client-5.6.41
apr-1.6.3.1.6.1_1
nextcloud-php71-14.0.0
apache24-2.4.34
ap24-mod_http2-devel-1.10.20
と言われるので、とりあえず、
/usr/ports/databases/mysql56-client make deinstall
portinstall databases/mysql57-client
===> openldap-sasl-client-2.4.46 conflicts with install...
openldap-client-2.4.46
They install files into the same place.
You may want to stop build with Ctrl + C.
===> License OPENLDAP accepted by the user
===> openldap-sasl-client-2.4.46 depends on file: /usr...
===> Fetching all distfiles required by openldap-sasl-cl...
===> openldap-sasl-client-2.4.46 conflicts with install...
openldap-client-2.4.46
They will not build together.
Please remove them first with pkg delete.
等とエラー。
openldap-client make deinstall
openldap24-client make deinstall
portinstall databases/mysql57-client
* * * * * * * * * * * * * * * * * * * * * * * *
This is the mysql CLIENT without the server.
for complete server and client, please install databases...
* * * * * * * * * * * * * * * * * * * * * * * *
===> Cleaning for openldap-sasl-client-2.4.46
===> Cleaning for cyrus-sasl-2.1.26_13
===> Cleaning for protobuf-3.5.2_1,1
===> Cleaning for mysql57-client-5.7.23
* portinstall mysql57-server [#g59184f6]
/etc/rc.conf
mysql_enable="YES"
デフォルトでは /var/db/mysql にデータベースファイルが作成...
2018-09-24T04:39:17.287395Z 0 [Warning] Could not increa...
2018-09-24T04:39:17.287598Z 0 [Warning] Changed limits: ...
2018-09-24T04:39:17.504113Z 0 [Note] /usr/local/libexec/...
2018-09-24T04:39:17.550561Z 0 [Note] InnoDB: Mutexes and...
2018-09-24T04:39:17.550619Z 0 [Note] InnoDB: Uses event ...
2018-09-24T04:39:17.550630Z 0 [Note] InnoDB: GCC builtin...
2018-09-24T04:39:17.550640Z 0 [Note] InnoDB: Compressed ...
2018-09-24T04:39:17.551077Z 0 [Note] InnoDB: Number of p...
2018-09-24T04:39:17.551222Z 0 [Note] InnoDB: Not using C...
2018-09-24T04:39:17.553732Z 0 [Note] InnoDB: Initializin...
2018-09-24T04:39:17.745413Z 0 [Note] InnoDB: Completed i...
2018-09-24T04:39:17.779117Z 0 [ERROR] InnoDB: The Auto-e...
2018-09-24T04:39:17.779158Z 0 [ERROR] InnoDB: Plugin ini...
2018-09-24T04:39:17.993508Z 0 [ERROR] Plugin 'InnoDB' in...
2018-09-24T04:39:17.993529Z 0 [ERROR] Plugin 'InnoDB' re...
2018-09-24T04:39:17.993541Z 0 [ERROR] Failed to initiali...
2018-09-24T04:39:17.993550Z 0 [ERROR] Aborting
2018-09-24T04:39:17.993562Z 0 [Note] Binlog end
2018-09-24T04:39:17.993627Z 0 [Note] Shutting down plugi...
2018-09-24T04:39:17.996147Z 0 [Note] /usr/local/libexec/...
error で起動できません。ググルと、https://piano2nd.smb.ne...
/usr/local/etc/mysql/my.cnf
#innodb_data_file_path = ibdata1:128M:autoextend
の行をコメントアウトしたら、起動した。
mysql_dbdir="/path/to/mysql"
以下の起動スクリプトで制御できます。
# /usr/local/etc/rc.d/mysql-server start ←デーモンを起動...
# /usr/local/etc/rc.d/mysql-server restart ←デーモンを再...
# /usr/local/etc/rc.d/mysql-server stop ←デーモンを停止...
起動できたら、rootユーザのパスワードを設定します。初期状...
# mysqladmin -u root -h localhost password 'XXXXXX' ←XXX...
ココでエラー。
mysqladmin: [Warning] Using a password on the command li...
Warning: Since password will be sent to server in plain ...
mysqladmin: unable to change password; error: 'Column co...
Please use mysql_upgrade to fix this error.'
エラーメッセージ通り mysql_upgrade する。
root@k154:~ # mysql_upgrade
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Upgrading the sys schema.
Checking databases.
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
で、やっと、root パスワード設定。
root@k154:~ # mysqladmin -u root -h localhost password '...
mysqladmin: [Warning] Using a password on the command li...
Warning: Since password will be sent to server in plain ...
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
終了行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mysql56 to 57 [#j68ae7e0]
https://freebsd.sing.ne.jp/11.01/09/03.html
[[「MySQL で my.cnf のシンタックスチェックを行う方法」:ht...
/usr/local/libexec/mysqld --verbose --help > /dev/null
**pkg delete mysql56-client-5.6.41 [#xfd49d41]
Installed packages to be REMOVED:
mysql56-client-5.6.41
apr-1.6.3.1.6.1_1
nextcloud-php71-14.0.0
apache24-2.4.34
ap24-mod_http2-devel-1.10.20
と言われるので、とりあえず、
/usr/ports/databases/mysql56-client make deinstall
portinstall databases/mysql57-client
===> openldap-sasl-client-2.4.46 conflicts with install...
openldap-client-2.4.46
They install files into the same place.
You may want to stop build with Ctrl + C.
===> License OPENLDAP accepted by the user
===> openldap-sasl-client-2.4.46 depends on file: /usr...
===> Fetching all distfiles required by openldap-sasl-cl...
===> openldap-sasl-client-2.4.46 conflicts with install...
openldap-client-2.4.46
They will not build together.
Please remove them first with pkg delete.
等とエラー。
openldap-client make deinstall
openldap24-client make deinstall
portinstall databases/mysql57-client
* * * * * * * * * * * * * * * * * * * * * * * *
This is the mysql CLIENT without the server.
for complete server and client, please install databases...
* * * * * * * * * * * * * * * * * * * * * * * *
===> Cleaning for openldap-sasl-client-2.4.46
===> Cleaning for cyrus-sasl-2.1.26_13
===> Cleaning for protobuf-3.5.2_1,1
===> Cleaning for mysql57-client-5.7.23
* portinstall mysql57-server [#g59184f6]
/etc/rc.conf
mysql_enable="YES"
デフォルトでは /var/db/mysql にデータベースファイルが作成...
2018-09-24T04:39:17.287395Z 0 [Warning] Could not increa...
2018-09-24T04:39:17.287598Z 0 [Warning] Changed limits: ...
2018-09-24T04:39:17.504113Z 0 [Note] /usr/local/libexec/...
2018-09-24T04:39:17.550561Z 0 [Note] InnoDB: Mutexes and...
2018-09-24T04:39:17.550619Z 0 [Note] InnoDB: Uses event ...
2018-09-24T04:39:17.550630Z 0 [Note] InnoDB: GCC builtin...
2018-09-24T04:39:17.550640Z 0 [Note] InnoDB: Compressed ...
2018-09-24T04:39:17.551077Z 0 [Note] InnoDB: Number of p...
2018-09-24T04:39:17.551222Z 0 [Note] InnoDB: Not using C...
2018-09-24T04:39:17.553732Z 0 [Note] InnoDB: Initializin...
2018-09-24T04:39:17.745413Z 0 [Note] InnoDB: Completed i...
2018-09-24T04:39:17.779117Z 0 [ERROR] InnoDB: The Auto-e...
2018-09-24T04:39:17.779158Z 0 [ERROR] InnoDB: Plugin ini...
2018-09-24T04:39:17.993508Z 0 [ERROR] Plugin 'InnoDB' in...
2018-09-24T04:39:17.993529Z 0 [ERROR] Plugin 'InnoDB' re...
2018-09-24T04:39:17.993541Z 0 [ERROR] Failed to initiali...
2018-09-24T04:39:17.993550Z 0 [ERROR] Aborting
2018-09-24T04:39:17.993562Z 0 [Note] Binlog end
2018-09-24T04:39:17.993627Z 0 [Note] Shutting down plugi...
2018-09-24T04:39:17.996147Z 0 [Note] /usr/local/libexec/...
error で起動できません。ググルと、https://piano2nd.smb.ne...
/usr/local/etc/mysql/my.cnf
#innodb_data_file_path = ibdata1:128M:autoextend
の行をコメントアウトしたら、起動した。
mysql_dbdir="/path/to/mysql"
以下の起動スクリプトで制御できます。
# /usr/local/etc/rc.d/mysql-server start ←デーモンを起動...
# /usr/local/etc/rc.d/mysql-server restart ←デーモンを再...
# /usr/local/etc/rc.d/mysql-server stop ←デーモンを停止...
起動できたら、rootユーザのパスワードを設定します。初期状...
# mysqladmin -u root -h localhost password 'XXXXXX' ←XXX...
ココでエラー。
mysqladmin: [Warning] Using a password on the command li...
Warning: Since password will be sent to server in plain ...
mysqladmin: unable to change password; error: 'Column co...
Please use mysql_upgrade to fix this error.'
エラーメッセージ通り mysql_upgrade する。
root@k154:~ # mysql_upgrade
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Upgrading the sys schema.
Checking databases.
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
で、やっと、root パスワード設定。
root@k154:~ # mysqladmin -u root -h localhost password '...
mysqladmin: [Warning] Using a password on the command li...
Warning: Since password will be sent to server in plain ...
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
