![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2019-02-12 (火) 14:30:18
portinstall mysql57-server
スクラッチインストールで出るエラー
===> openldap-sasl-client-2.4.47 conflicts with installed package(s):
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/local/sbin/pkg - found
===> Fetching all distfiles required by openldap-sasl-client-2.4.47 for building
===> openldap-sasl-client-2.4.47 conflicts with installed package(s):
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 packages (of 0 packages in the universe):
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
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 the MySQL server after an upgrade from an earlier version. Initial password for first time use of MySQL is saved in $HOME/.mysql_secret ie. when you want to use "mysql -u root -p" first you should see password 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 にあるので、コレでログインし、パスワードを変更するには
SET PASSWORD FOR ユーザ名@ホスト名=password('新しいパスワード');
https://qiita.com/unbabel/items/b784459356686641dabe
$ mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
# /usr/local/etc/rc.d/mysql-server stop
$ mysqld_safe --skip-grant-tables --skip-networking
別のターミナルでMySQLを開く：
$ mysql
mysql> update user set authentication_string=password('PASSWORD') where user='root'；
https://qiita.com/garicchi/items/822ec2a074f09e0451c5
https://yoku0825.blogspot.com/2015/06/mysql-574defaultpasswordlifetime.html
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure. mysql_upgrade: Got error: 1862: Your password has expired. To log in you must change it using a client that supports expired passwords. while connecting to the MySQL server Upgrade process encountered error and will not continue.
root@localhost [(none)]> alter user root password expire default;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
root@localhost [(none)]> SET PASSWORD FOR root@localhost=PASSWORD('hoge');
Query OK, 0 rows affected, 1 warning (0.00 sec)
root@localhost [(none)]> SET PASSWORD FOR root@localhost=PASSWORD('xxxxxxxx');
Query OK, 0 rows affected, 1 warning (0.00 sec)
root@localhost [(none)]> exit
Bye
/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
Total access 1235：本日 1：昨日 0
