mysql57
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mysql57 [#efe61741]
portinstall mysql57-server
スクラッチインストールで出るエラー
===> openldap-sasl-client-2.4.47 conflicts with install...
openldap-client-2.4.47
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.47 depends on file: /usr...
===> Fetching all distfiles required by openldap-sasl-cl...
===> openldap-sasl-client-2.4.47 conflicts with install...
openldap-client-2.4.47
They will not build together.
Please remove them first with pkg delete.
*** Error code 1
Stop.
make[5]: stopped in /usr/ports/net/openldap24-sasl-client
*** Error code 1
# pkg info -r openldap-client-2.4.47
openldap-client-2.4.47:
php72-ldap-7.2.14_1
# pkg delete openldap-client-2.4.47
Updating database digests format: 100%
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 3 pa...
Installed packages to be REMOVED:
openldap-client-2.4.47
php72-ldap-7.2.14_1
php72-extensions-1.0
Number of packages to be removed: 3
The operation will free 6 MiB.
Proceed with deinstalling packages? [y/N]: y
----
www 本番環境だとこう
Installed packages to be REMOVED:
openldap-client-2.4.47
php71-ldap-7.1.26_1
php71-extensions-1.0
----
Sun1はこう
Installed packages to be REMOVED:
openldap-client-2.4.47
ldb-1.1.29_2
samba46-4.6.16_1
php71-ldap-7.1.26_1
php71-pecl-smbclient-1.0.0
php71-extensions-1.0
----
Installing mysql57-server-5.7.25...
===> Creating groups.
Creating group 'mysql' with gid '88'.
===> Creating users
Creating user 'mysql' with uid '88'.
********************************************************...
Remember to run mysql_upgrade the first time you start t...
after an upgrade from an earlier version.
Initial password for first time use of MySQL is saved in...
ie. when you want to use "mysql -u root -p" first you sh...
in /root/.mysql_secret
MySQL57 has a default %%ETCDIR%%/my.cnf,
remember to replace it wit your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
********************************************************...
===> Cleaning for mysql57-client-5.7.25
===> Cleaning for openldap-sasl-client-2.4.47
===> Cleaning for cyrus-sasl-2.1.27
===> Cleaning for mysql57-server-5.7.25
1011 11:14 portinstall php72-ldap
1012 11:15 portinstall php72-extensions
インストール直後のrootパスワードは、/root/.mysql_secret ...
**MySQLからパスワードを変更する [#v0b3b691]
SET PASSWORD FOR ユーザ名@ホスト名=password('新しいパス...
----
*** Safe mode でMySQL起動してパスワード変更 [#j559b6f2]
https://qiita.com/unbabel/items/b784459356686641dabe
$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'local...
# /usr/local/etc/rc.d/mysql-server stop
$ mysqld_safe --skip-grant-tables --skip-networking
別のターミナルでMySQLを開く：
$ mysql
mysql> update user set authentication_string=password('P...
https://qiita.com/garicchi/items/822ec2a074f09e0451c5
https://yoku0825.blogspot.com/2015/06/mysql-574defaultpas...
mysql_upgrade: [Warning] Using a password on the command...
mysql_upgrade: Got error: 1862: Your password has expire...
Upgrade process encountered error and will not continue.
root@localhost [(none)]> alter user root password expire...
ERROR 1820 (HY000): You must reset your password using A...
root@localhost [(none)]> SET PASSWORD FOR root@localhost...
Query OK, 0 rows affected, 1 warning (0.00 sec)
root@localhost [(none)]> SET PASSWORD FOR root@localhost...
Query OK, 0 rows affected, 1 warning (0.00 sec)
root@localhost [(none)]> exit
Bye
**Data_dir変更 [#i6880b82]
/usr/ports/databases/mysql57-server/Makefile
MY_DBDIR= /usr/home/mysql
MY_SECDIR= /usr/home/mysql_secure
MY_TMPDIR= /usr/home/mysql_tmpdir
と変えたいデータディレクトリで、コンパイルするのが確実か。
/usr/local/etc/mysql/my.cnf
#datadir = /var/db/mysql
datadir = /usr/home/mysql
#innodb_data_home_dir = /var/db/mysql
#innodb_log_group_home_dir = /var/db/mysql
innodb_data_home_dir = /usr/home/mysql
innodb_log_group_home_dir = /usr/home/mysql
* SQLSTATE[42000]: Syntax error or access violation: 1055...
https://www.p-nt.com/technicblog/archives/204
my.cnfでsql_modeを変更します。
my.cnfの場所は、 mysql --help | grep my.cnf で表示される...
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DAT...
sql_modeで、ONLY_FULL_GROUP_BYを未指定にします。
必要に応じてsql_modeの内容は変更してください。
MySQLを再起動してあげればエラーが表示されなくなります。
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
終了行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mysql57 [#efe61741]
portinstall mysql57-server
スクラッチインストールで出るエラー
===> openldap-sasl-client-2.4.47 conflicts with install...
openldap-client-2.4.47
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.47 depends on file: /usr...
===> Fetching all distfiles required by openldap-sasl-cl...
===> openldap-sasl-client-2.4.47 conflicts with install...
openldap-client-2.4.47
They will not build together.
Please remove them first with pkg delete.
*** Error code 1
Stop.
make[5]: stopped in /usr/ports/net/openldap24-sasl-client
*** Error code 1
# pkg info -r openldap-client-2.4.47
openldap-client-2.4.47:
php72-ldap-7.2.14_1
# pkg delete openldap-client-2.4.47
Updating database digests format: 100%
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 3 pa...
Installed packages to be REMOVED:
openldap-client-2.4.47
php72-ldap-7.2.14_1
php72-extensions-1.0
Number of packages to be removed: 3
The operation will free 6 MiB.
Proceed with deinstalling packages? [y/N]: y
----
www 本番環境だとこう
Installed packages to be REMOVED:
openldap-client-2.4.47
php71-ldap-7.1.26_1
php71-extensions-1.0
----
Sun1はこう
Installed packages to be REMOVED:
openldap-client-2.4.47
ldb-1.1.29_2
samba46-4.6.16_1
php71-ldap-7.1.26_1
php71-pecl-smbclient-1.0.0
php71-extensions-1.0
----
Installing mysql57-server-5.7.25...
===> Creating groups.
Creating group 'mysql' with gid '88'.
===> Creating users
Creating user 'mysql' with uid '88'.
********************************************************...
Remember to run mysql_upgrade the first time you start t...
after an upgrade from an earlier version.
Initial password for first time use of MySQL is saved in...
ie. when you want to use "mysql -u root -p" first you sh...
in /root/.mysql_secret
MySQL57 has a default %%ETCDIR%%/my.cnf,
remember to replace it wit your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
********************************************************...
===> Cleaning for mysql57-client-5.7.25
===> Cleaning for openldap-sasl-client-2.4.47
===> Cleaning for cyrus-sasl-2.1.27
===> Cleaning for mysql57-server-5.7.25
1011 11:14 portinstall php72-ldap
1012 11:15 portinstall php72-extensions
インストール直後のrootパスワードは、/root/.mysql_secret ...
**MySQLからパスワードを変更する [#v0b3b691]
SET PASSWORD FOR ユーザ名@ホスト名=password('新しいパス...
----
*** Safe mode でMySQL起動してパスワード変更 [#j559b6f2]
https://qiita.com/unbabel/items/b784459356686641dabe
$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'local...
# /usr/local/etc/rc.d/mysql-server stop
$ mysqld_safe --skip-grant-tables --skip-networking
別のターミナルでMySQLを開く：
$ mysql
mysql> update user set authentication_string=password('P...
https://qiita.com/garicchi/items/822ec2a074f09e0451c5
https://yoku0825.blogspot.com/2015/06/mysql-574defaultpas...
mysql_upgrade: [Warning] Using a password on the command...
mysql_upgrade: Got error: 1862: Your password has expire...
Upgrade process encountered error and will not continue.
root@localhost [(none)]> alter user root password expire...
ERROR 1820 (HY000): You must reset your password using A...
root@localhost [(none)]> SET PASSWORD FOR root@localhost...
Query OK, 0 rows affected, 1 warning (0.00 sec)
root@localhost [(none)]> SET PASSWORD FOR root@localhost...
Query OK, 0 rows affected, 1 warning (0.00 sec)
root@localhost [(none)]> exit
Bye
**Data_dir変更 [#i6880b82]
/usr/ports/databases/mysql57-server/Makefile
MY_DBDIR= /usr/home/mysql
MY_SECDIR= /usr/home/mysql_secure
MY_TMPDIR= /usr/home/mysql_tmpdir
と変えたいデータディレクトリで、コンパイルするのが確実か。
/usr/local/etc/mysql/my.cnf
#datadir = /var/db/mysql
datadir = /usr/home/mysql
#innodb_data_home_dir = /var/db/mysql
#innodb_log_group_home_dir = /var/db/mysql
innodb_data_home_dir = /usr/home/mysql
innodb_log_group_home_dir = /usr/home/mysql
* SQLSTATE[42000]: Syntax error or access violation: 1055...
https://www.p-nt.com/technicblog/archives/204
my.cnfでsql_modeを変更します。
my.cnfの場所は、 mysql --help | grep my.cnf で表示される...
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DAT...
sql_modeで、ONLY_FULL_GROUP_BYを未指定にします。
必要に応じてsql_modeの内容は変更してください。
MySQLを再起動してあげればエラーが表示されなくなります。
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
